Re: using adbin, conbin, etc.

Lists: pgsql-hackers
From: "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>
To: "Hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: using adbin, conbin, etc.
Date: 2003-07-30 01:45:32
Message-ID: 08f101c3563c$43e232f0$2800a8c0@mars
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

Hi guys,

I hear that we're supposed to use the 'bin' versions of the 'src' columns
where possible. I would like then to use them in phpPgAdmin for displaying
defaults and stuff. Is there some way to use them from SQL? Cos it all
looks like garbage to me :)

Chris

From: Rod Taylor <rbt(at)rbt(dot)ca>
To: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
Cc: Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: using adbin, conbin, etc.
Date: 2003-07-30 02:11:15
Message-ID: 1059531074.54325.15.camel@jester
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

On Tue, 2003-07-29 at 21:45, Christopher Kings-Lynne wrote:
> Hi guys,
>
> I hear that we're supposed to use the 'bin' versions of the 'src' columns
> where possible. I would like then to use them in phpPgAdmin for displaying
> defaults and stuff. Is there some way to use them from SQL? Cos it all
> looks like garbage to me :)

Use the various pg_get_...() functions wherever you can.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Rod Taylor <rbt(at)rbt(dot)ca>
Cc: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>, Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: using adbin, conbin, etc.
Date: 2003-07-30 14:39:21
Message-ID: 9688.1059575961@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

Rod Taylor <rbt(at)rbt(dot)ca> writes:
> On Tue, 2003-07-29 at 21:45, Christopher Kings-Lynne wrote:
>> I hear that we're supposed to use the 'bin' versions of the 'src' columns
>> where possible. I would like then to use them in phpPgAdmin for displaying
>> defaults and stuff. Is there some way to use them from SQL? Cos it all
>> looks like garbage to me :)

> Use the various pg_get_...() functions wherever you can.

And if you can't find one that does what you want, ask for it.
The last thing we want is client-side code digging into those internal
representations --- we change 'em frequently.

regards, tom lane

From: "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>
To: "Rod Taylor" <rbt(at)rbt(dot)ca>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: using adbin, conbin, etc.
Date: 2003-07-31 01:28:52
Message-ID: 0c6501c35703$1b5e2920$2800a8c0@mars
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

> > Use the various pg_get_...() functions wherever you can.
>
> And if you can't find one that does what you want, ask for it.
> The last thing we want is client-side code digging into those internal
> representations --- we change 'em frequently.

I want pg_get_* functions for every PostgreSQL object :P

Chris

From: "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>
To: "Rod Taylor" <rbt(at)rbt(dot)ca>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: using adbin, conbin, etc.
Date: 2003-07-31 01:37:04
Message-ID: 0d2101c35704$3f02f530$2800a8c0@mars
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

> > And if you can't find one that does what you want, ask for it.
> > The last thing we want is client-side code digging into those internal
> > representations --- we change 'em frequently.
>
> I want pg_get_* functions for every PostgreSQL object :P

And I want an easy way of parsing aclitem[]'s so I don't have to do it
manually in PHP, trying to handle usernames and grantors that have commas,
spaces, backslashes and double quotes in them...

Chris