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


Wed, 30 Jul 2003 09:45:32 +0800
"Christopher Kings-Lynne" <chriskl@familyhealth.com.au>
using adbin, conbin, etc.
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.
29 Jul 2003 22:11:15 -0400
Rod Taylor <rbt@rbt.ca>
Re: using adbin, conbin, etc.
Rod Taylor <rbt@rbt.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

Wed, 30 Jul 2003 10:39:21 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: using adbin, conbin, etc. 
> > 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


Thu, 31 Jul 2003 09:28:52 +0800
"Christopher Kings-Lynne" <chriskl@familyhealth.com.au>
Re: using adbin, conbin, etc. 
> > 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


Thu, 31 Jul 2003 09:37:04 +0800
"Christopher Kings-Lynne" <chriskl@familyhealth.com.au>
Re: using adbin, conbin, etc. 