Re: [HACKERS] Request for qualified column names

2003-01-29 Thread Reggie Burnett
someone requests it. Reggie > -Original Message- > From: Neil Conway [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, January 28, 2003 11:47 PM > To: Reggie Burnett > Cc: 'Tom Lane'; 'Dave Cramer'; 'PostgreSQL Hackers Mailing List' > Subject: Re: [

Re: [HACKERS] Request for qualified column names

2003-01-28 Thread Reggie Burnett
Original Message- > From: Bruce Momjian [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, January 28, 2003 4:01 PM > To: Peter Eisentraut > Cc: Tom Lane; Reggie Burnett; 'Dave Cramer'; 'PostgreSQL Hackers Mailing > List' > Subject: Re: [HACKERS] Request for qualifi

Re: [HACKERS] Request for qualified column names

2003-01-28 Thread Reggie Burnett
aut [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, January 28, 2003 3:59 PM > To: Bruce Momjian > Cc: Tom Lane; Reggie Burnett; 'Dave Cramer'; 'PostgreSQL Hackers Mailing > List' > Subject: Re: [HACKERS] Request for qualified column names > > Bruce Momjian writes

Re: [HACKERS] Request for qualified column names

2003-01-27 Thread Reggie Burnett
1 AM > To: Reggie Burnett > Cc: 'Dave Cramer'; 'PostgreSQL Hackers Mailing List' > Subject: Re: [HACKERS] Request for qualified column names > > "Reggie Burnett" <[EMAIL PROTECTED]> writes: > > When talking about expressions,views, or any other

Re: [HACKERS] how do I get the table name from a query?

2003-01-27 Thread Reggie Burnett
the source table name, I would have to parse this myself? Reggie > -Original Message- > From: [EMAIL PROTECTED] [mailto:pgsql-hackers- > [EMAIL PROTECTED]] On Behalf Of Dave Cramer > Sent: Monday, January 27, 2003 8:42 AM > To: Reggie Burnett > Cc: 'Hackers' >

Re: [HACKERS] Request for qualified column names

2003-01-27 Thread Reggie Burnett
When talking about expressions,views, or any other construct that could combine values from multiple tables I think it is reasonable to provide null as the table name. Any one or any process requesting the table name has to understand that not all SQL parameters have a base table name. However, i

[HACKERS] how do I get the table name from a query?

2003-01-27 Thread Reggie Burnett
When using the FE/BE, how do I retrieve the table name for a given column?  Say I had the following SQL:   Select c.id, c.name, d.phone from Members c, Addresses d where c.id < 200   From the docs of the FE/BE, I would see that the fields are named id, name, phone but how do I find out

Re: [HACKERS] pgsql oid question

2003-01-04 Thread Reggie Burnett
determine the datatype for a given oid. I know for user-defined types that is required, but for base types is it required? And thanks for the reply! Reggie > -Original Message- > From: Tom Lane [mailto:[EMAIL PROTECTED]] > Sent: Sunday, January 05, 2003 12:42 AM > To: Reggie

[HACKERS] pgsql oid question

2003-01-04 Thread Reggie Burnett
I have started experimenting with an access layer for pgsql and have a question. I had someone on this list tell me that the oid values that come back from the server are tag identifiers for that row/column combination and are not type indicators. Yet, when I create multiple tables/columns each h

Re: [HACKERS] new interface

2002-12-06 Thread Reggie Burnett
join of pg_class and pg_attribute. Am I understanding this right? > -Original Message- > From: Rod Taylor [mailto:[EMAIL PROTECTED]] > Sent: Friday, December 06, 2002 9:19 AM > To: Reggie Burnett > Cc: PostgreSQL-development > Subject: Re: [HACKERS] new interface >

Re: [HACKERS] new interface

2002-12-06 Thread Reggie Burnett
> -Original Message- > From: Rod Taylor [mailto:[EMAIL PROTECTED]] > Sent: Friday, December 06, 2002 9:19 AM > To: Reggie Burnett > Cc: PostgreSQL-development > Subject: Re: [HACKERS] new interface > > On Fri, 2002-12-06 at 09:55, Reggie Burnett wrote: > >

[HACKERS] new interface

2002-12-06 Thread Reggie Burnett
I'm working on a new interface to PostgreSQL and having a difficult time. Perhaps someone here can shed some light on the subject. 1.  Am I correct in thinking that the OID that I receive with the RowDescription is the column type?  I have several of those defined from the 7.3 source code.  Have t