Re: [GENERAL] Parser does not like %ROWTYPE in the RETURNS clause of a

2003-12-24 Thread Sai Hertz And Control Systems
Dear ezra epstein ; Using Postgres 7.4, the function "test" gets this: psql:temp3.sql:10: ERROR: syntax error at or near "%" at character 135 the function "test2" gets this: psql:temp3.sql:10: ERROR: syntax error at or near "ROWTYPE" at character 141 Very odd. The first doesn't even like t

Re: [GENERAL] Parser does not like %ROWTYPE in the RETURNS clause

2003-12-24 Thread Ron St-Pierre
ezra epstein wrote: Aother head banger for me. Below is a complete example of the code Using Postgres 7.4, the function "test" gets this: psql:temp3.sql:10: ERROR: syntax error at or near "%" at character 135 the function "test2" gets this: psql:temp3.sql:10: ERROR: syntax error at or nea

Re: [GENERAL] Parser: parse error - please help...

2003-12-22 Thread Alvaro Herrera
On Mon, Dec 22, 2003 at 04:24:52PM -0700, Andrew Ayers wrote: > INSERT INTO reg("customer number", "company name", address, city, state, > zip, phone, alt_phone, fax, alt_fax, iaccess, browser, provider, > software, sversion, ynintegrated, ynnewtest, login, password, txtnetid, > alias_1, alias_

Re: [GENERAL] parser

2000-01-20 Thread Sarah Officer
I had this problem a couple years ago. I changed the column name before the upgrade by renaming the table to table_old, creating a new table with the original table name by selecting from table_old. For the column I needed to rename, I selected offset as 'x_offset'. I made sure everything was