Re: [GENERAL] existence of column name

2009-04-15 Thread Eric Smith
Tried this out, and got a very familiar error that I don't know what to do with : Error: expected just one rule action. I'm using 8.3.5, and see this error quite a bit. Anyone know what's behind this error? Thanks, Eric On Apr 8, 2009, at 8:54 PM, John R Pierce wrote: Eric Smith

Re: [GENERAL] existence of column name

2009-04-15 Thread Tom Lane
Eric Smith eric_h_sm...@mac.com writes: Tried this out, and got a very familiar error that I don't know what to do with : Error: expected just one rule action. Er, tried *what* out? That's supposed to be a can't-happen case, so I'd like to see just what you did to trigger it.

Re: [GENERAL] existence of column name

2009-04-11 Thread Jasen Betts
On 2009-04-09, Eric Smith eric_h_sm...@mac.com wrote: All, From the C API, how do I check for the existence of a column name in a given table? you can look at the information schema, column-names in a result-set, or error messages. which is most apropriate depends on the context. --

[GENERAL] existence of column name

2009-04-08 Thread Eric Smith
All, From the C API, how do I check for the existence of a column name in a given table? Thanks, Eric -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] existence of column name

2009-04-08 Thread John R Pierce
Eric Smith wrote: All, From the C API, how do I check for the existence of a column name in a given table? select data_type from information_schema.columns where table_schema='public' and table_name='given_table' and column_name='some_column'; that will return the data_type if the