Re: [BUGS] BUG: mismatched parentheses

2002-06-03 Thread Stephan Szabo
On Tue, 28 May 2002, Brendon Matthews wrote: > Hi, > > I have found a bug in PostgreSQL 7.2.1. > > I am trying to use plpgsql to run a simple INSERT on a table, and it always > comes up with an error saying "mismatched parentheses" > > I firstly store the SQL in a TEXT variable: > a_sql := ''INS

[BUGS] BUG: mismatched parentheses

2002-06-01 Thread Brendon Matthews
Hi, I have found a bug in PostgreSQL 7.2.1. I am trying to use plpgsql to run a simple INSERT on a table, and it always comes up with an error saying "mismatched parentheses" I firstly store the SQL in a TEXT variable: a_sql := ''INSERT INTO mytable(theid,thenumber) VALUES(1,2);''; Then i run