Re: [BUGS] Documentation regarding %ROWTYPE in PL/PgSQL

2002-06-13 Thread Bruce Momjian
Your patch has been added to the PostgreSQL unapplied patches list at: http://candle.pha.pa.us/cgi-bin/pgpatches I will try to apply it within the next 48 hours. --- Andrew McMillan wrote: > On Wed, 2002-05-29 at

Re: [BUGS] PgLargeObject bug

2002-06-13 Thread Bruce Momjian
Your patch has been added to the PostgreSQL unapplied patches list at: http://candle.pha.pa.us/cgi-bin/pgpatches I will try to apply it within the next 48 hours. --- Chris Traylor wrote: > see attachment. > > --

Re: [BUGS] Problems with select chaining using INTERSECT

2002-06-13 Thread Stephan Szabo
On Thu, 13 Jun 2002, Michael Beckstette wrote: > Version: PostgreSQL 7.1.2 on sparc-sun-solaris2.5.1, compiled by GCC 2.95 > > Hi, when using SELECT queries chained by INTERSECT i get confused about the > behavour of the INTERSECT operation. I try to outline this with the following > examples.

Re: [BUGS] Problems with select chaining using INTERSECT

2002-06-13 Thread Tom Lane
"Michael Beckstette" <[EMAIL PROTECTED]> writes: > Version: PostgreSQL 7.1.2 on sparc-sun-solaris2.5.1, compiled by GCC 2.95 > Hi, when using SELECT queries chained by INTERSECT i get confused about the > behavour of the INTERSECT operation. Nested INTERSECT and EXCEPT queries are broken in 7.1.*

Re: [BUGS] cannot connect to database and strange error

2002-06-13 Thread Tom Lane
Massimiliano Panichi <[EMAIL PROTECTED]> writes: > bash$ psql whatsdown > FATAL 1: FillScanKeyEntry: no procedure for operator 661 > Connection to database 'whatsdown' failed. Hmmm... test72=# select * from pg_operator where oid = 661; oprname | oprowner | oprprec | oprkind | oprisleft | oprca

[BUGS] Problems with select chaining using INTERSECT

2002-06-13 Thread Michael Beckstette
Version: PostgreSQL 7.1.2 on sparc-sun-solaris2.5.1, compiled by GCC 2.95 Hi, when using SELECT queries chained by INTERSECT i get confused about the behavour of the INTERSECT operation. I try to outline this with the following examples. Example (Field query_desc is of type TEXT): select query_

[BUGS] cannot connect to database and strange error

2002-06-13 Thread Massimiliano Panichi
Every time I try to connect to the database, I get this bash$ psql whatsdown FATAL 1: FillScanKeyEntry: no procedure for operator 661 Connection to database 'whatsdown' failed. FATAL 1: FillScanKeyEntry: no procedure for operator 661 I haven't found info about the message. This happen with o

Re: [BUGS] to_date problem.

2002-06-13 Thread Tom Lane
lewwid <[EMAIL PROTECTED]> writes: > select to_date('January 12 2002','Month dd '); > to_date > > 0005-06-24 <- Problem right there. I think you need FM: regression=# select to_date('January 12 2002','FMMonth dd '); to_date 2002-01-12 (1 r

[BUGS] select real returns nothing

2002-06-13 Thread Chris Sutton
I'm getting some weird things happen when trying to search for a specific row in a table that contains "real" types. Here is my table structure table units ( unit_id int4, price_unit varchar(10), unit_covreal, unit_wt real); The following row exists

[BUGS] to_date bug

2002-06-13 Thread Jeff
select to_date('December 12 2002','Month dd '); to_date 2002-12-02 select to_date('January 12 2002','Month dd '); to_date 0005-06-24 <- Problem right there. select to_date('January 12, 2002','Month dd, '); to_date -