Re: cast bytea to macaddr

From: Boris Zentner <bzm(at)2bz(dot)de>
To: Matt Zagrabelny <mzagrabe(at)d(dot)umn(dot)edu>
Cc: "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: cast bytea to macaddr
Date: 2023-09-28 20:34:32
Message-ID: 93E6A5CA-A94E-4266-8432-AD15FAB56041@2bz.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Hi Matt,

>
> 1. What do the double parenthesis '(( Values .... ))' mean?

Nothing, it was easier to continue typing and close one more on the phone. Single parenthesis are enough.

>
> 2. What is the 'x(field)' in the column alias?

X(field) is just to make the example more readable. And name the example table x with the column field to illustrate the main part of the example encode(yourfield, 'hex')::macaddr

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ron 2023-09-28 20:38:54 Re: Right version of jdbc
Previous Message Dave Cramer 2023-09-28 20:06:36 Re: Right version of jdbc