Re: [HACKERS] PLPGSQL bug in implicit SELECT

2001-08-16 Thread Tom Lane
Kovacs Zoltan <[EMAIL PROTECTED]> writes: > Unfortunately I'm getting > testdb=# select testfunc(); > ERROR: query "SELECT column1 FROM table WHERE column2 LIKE '%anything%' > ORDER BY column3 LIMIT 1" returned more than one column This appears fixed in current sources. I believe the relevant

[HACKERS] PLPGSQL bug in implicit SELECT

2001-08-16 Thread Kovacs Zoltan
After more than 3 months of hard testing I found a small bug in PLPGSQL. (It works _too_ fine due to your excellent work... :-) Thanks!) Consider this function: CREATE FUNCTION testfunc () RETURNS int4 AS ' declare ret int4; begin ret := column1 FROM table WHERE column2 LIKE ''%anything%''