Re: [SQL] SQL Standatd

2004-04-07 Thread Bruce Momjian
Joe Conway wrote: > Bruce Momjian wrote: > > Martin Marques wrote: > >>Also, for some reason I can't get to sqlstandards.org. Is there any other > >>place where I can get the SQL200X docs? > > > > Not sure. > > See: > http://www.wiscorp.com/sql/sql_2003_standard.zip Thanks, I have added this to

Re: [SQL] SQL Standatd

2004-04-07 Thread Joe Conway
Bruce Momjian wrote: Martin Marques wrote: Also, for some reason I can't get to sqlstandards.org. Is there any other place where I can get the SQL200X docs? Not sure. See: http://www.wiscorp.com/sql/sql_2003_standard.zip Joe ---(end of broadcast)---

Re: [SQL] SQL Standatd

2004-04-07 Thread Bruce Momjian
Martin Marques wrote: > El Mi? 07 Abr 2004 11:26, escribi?: > > Ricardo Vaz Mannrich wrote: > > > Thank you. > > > > > > I think there is an error in the Develpoer's FAQ... > > > > > > http://developer.postgresql.org/ > > > http://developer.postgresql.org/readtext.php?src/FAQ/FAQ_DEV.html+Develop >

Re: [SQL] SQL Standatd

2004-04-07 Thread Martin Marques
El Mié 07 Abr 2004 11:26, escribió: > Ricardo Vaz Mannrich wrote: > > Thank you. > > > > I think there is an error in the Develpoer's FAQ... > > > > http://developer.postgresql.org/ > > http://developer.postgresql.org/readtext.php?src/FAQ/FAQ_DEV.html+Develop > >ers-FAQ > > > > A lot of ugly charac

[SQL] Row count after SELECT INTO?

2004-04-07 Thread Alexander M. Pravking
Dear SQL and plPgSQL gurus, I seek for your wisdom. I have a variable assignment via SELECT INTO in my function, and I want to separate 3 cases: 1) no rows found; 2) one row found; 3) many rows found (ambiguous select). The first case is simple, I use FOUND variable for it. But how about the thir

[SQL] varray? table of varchar?

2004-04-07 Thread Postgres User
Hi, I posted asking about varray a few days ago. Also I've run into an Oracle type that is defined as "table of varchar2(4000) index by binary_integer". Has anyone encountered either of these before? I'm not exactly sure what they do as I'm not an Oracle expert. So it is hard for me to see wha

Re: [SQL] notify and leaks?

2004-04-07 Thread Tom Lane
Theodore Petrosky <[EMAIL PROTECTED]> writes: > After all this conversation.. I guess my question is.. > am I leaking 'listens' if I don't close them properly? No. It may take awhile for the backend to realize the connection is dead (this is driven by RFC-specified TCP timeouts). Once it does, t

[SQL] notify and leaks?

2004-04-07 Thread Theodore Petrosky
I am using postgresql as the backend to a job tracking system. My front app is running only on Mac OS X. I have been using notifications from postgresql to tell my user if the current record they are looking at has been updated by someone else. Obviously I am only 'listening' when a user is looki

Re: [SQL] distinct values without seq scan

2004-04-07 Thread Josh Berkus
Bret, > I have a table indexed on a char(35) field and want a query to return a > distinct list of the values in this column. Is there some syntactical > magic I can do to get these values without a sequential scan? I assume, > ( here we go again ) that these values are in the index somewhere an

Re: [SQL] SQL Standatd

2004-04-07 Thread Bruce Momjian
Ricardo Vaz Mannrich wrote: > Thank you. > > I think there is an error in the Develpoer's FAQ... > > http://developer.postgresql.org/ > http://developer.postgresql.org/readtext.php?src/FAQ/FAQ_DEV.html+Developers-FAQ > > A lot of ugly characters. Until we fix the web site, please see doc/src/FA

Re: [SQL] SQL Standatd

2004-04-07 Thread Ricardo Vaz Mannrich
Thank you. I think there is an error in the Develpoer's FAQ... http://developer.postgresql.org/ http://developer.postgresql.org/readtext.php?src/FAQ/FAQ_DEV.html+Developers-FAQ A lot of ugly characters. Em Ter, 2004-04-06 às 16:01, Bruce Momjian escreveu: > Ricardo Vaz Mannrich wrote: > > In P

Re: [SQL] Function To Log Changes

2004-04-07 Thread Erik Thiele
On Mon, 5 Apr 2004 13:01:39 -0400 (EDT) "Gavin" <[EMAIL PROTECTED]> wrote: > Hi All, I have been tinkering with a function to log the changes made on > any column through a function and trigger. However, I cant think of a way > to make this work through pl/pgsql. Any one have any ideas, or is it