Re: [SQL] SELECT very slow

2005-06-09 Thread Thomas Kellerer
On 09.06.2005 02:06 Tom Lane wrote: > Thomas Kellerer <[EMAIL PROTECTED]> writes: > >>Is there anything I can do, to convince PG to return the first row more >>quickly? > > The solution is to use a cursor and FETCH a reasonably small number of > rows at a time. Thanks for all your answers. I

Re: [SQL] [despammed] rejecting characters in a field

2005-06-09 Thread Andreas Kretschmer
am 09.06.2005, um 3:29:15 -0500 mailte Bruno Wolff III folgendes: > On Thu, Jun 09, 2005 at 09:18:09 +0200, > Andreas Kretschmer <[EMAIL PROTECTED]> wrote: > > am 09.06.2005, um 12:36:31 +0530 mailte Kenneth Gonsalves folgendes: > > > hi > > > i have a table with a varchar field called 'name'.

Re: [SQL] [despammed] rejecting characters in a field

2005-06-09 Thread Bruno Wolff III
On Thu, Jun 09, 2005 at 09:18:09 +0200, Andreas Kretschmer <[EMAIL PROTECTED]> wrote: > am 09.06.2005, um 12:36:31 +0530 mailte Kenneth Gonsalves folgendes: > > hi > > i have a table with a varchar field called 'name'. I want postgres to > > reject any insert with characters defined as illegal

Re: [SQL] SELECT very slow

2005-06-09 Thread Thomas Kellerer
On 09.06.2005 02:06 Tom Lane wrote: > Thomas Kellerer <[EMAIL PROTECTED]> writes: > >>Is there anything I can do, to convince PG to return the first row more >>quickly? > > > libpq's API for PQresult is such that it really doesn't have any choice > but to collect the full result set before it

Re: [SQL] SELECT very slow

2005-06-09 Thread Volkan YAZICI
Hi, On 6/9/05, Thomas Kellerer <[EMAIL PROTECTED]> wrote: > No I want the whole result. As Tom underlined: On 6/9/05, Tom Lane <[EMAIL PROTECTED]> wrote: > The solution is to use a cursor and FETCH a reasonably > small number of rows at a time. AFAIC, query results are stored as arrays in PGres

Re: [SQL] Indices and user defined operators

2005-06-09 Thread Richard Huxton
Tom Lane wrote: I wrote: "Dmitri Bichko" <[EMAIL PROTECTED]> writes: So, is there any way to make these operators use an index defined as above? If you've set things up so that the operators are defined by inline-able SQL functions, I'd sort of expect it to fall out for free ... Now *th

Re: [despammed] [SQL] rejecting characters in a field

2005-06-09 Thread Andreas Kretschmer
am 09.06.2005, um 12:36:31 +0530 mailte Kenneth Gonsalves folgendes: > hi > i have a table with a varchar field called 'name'. I want postgres to > reject any insert with characters defined as illegal characters, for > example '*/^#'. How do i do this? With a RULE or a TRIGGER. Regards, Andre

Re: [despammed] [SQL] rejecting characters in a field

2005-06-09 Thread Michael Glaesemann
On Jun 9, 2005, at 4:18 PM, Andreas Kretschmer wrote: am 09.06.2005, um 12:36:31 +0530 mailte Kenneth Gonsalves folgendes: hi i have a table with a varchar field called 'name'. I want postgres to reject any insert with characters defined as illegal characters, for example '*/^#'. How do i do

[SQL] rejecting characters in a field

2005-06-09 Thread Kenneth Gonsalves
hi i have a table with a varchar field called 'name'. I want postgres to reject any insert with characters defined as illegal characters, for example '*/^#'. How do i do this? -- regards kg http://www.livejournal.com/users/lawgon tally ho! http://avsap.sourceforge.net ಇಂಡ್ಲಿನಕ್ಸ வாழ்க! ---

Re: [SQL] rejecting characters in a field

2005-06-09 Thread Gnanavel Shanmugam
add check constraint with following pattern check(name !~ '[*/^#]') with regards, S.Gnanavel > -Original Message- > From: [EMAIL PROTECTED] > Sent: Thu, 9 Jun 2005 12:36:31 +0530 > To: pgsql-sql@postgresql.org > Subject: [SQL] rejecting characters in a field > > hi > i have a table wit

Re: [SQL] SELECT very slow

2005-06-09 Thread Thomas Kellerer
On 09.06.2005 03:13 Alain wrote: > > > Tom Lane escreveu: > >> Thomas Kellerer <[EMAIL PROTECTED]> writes: >> >>> Is there anything I can do, to convince PG to return the first row >>> more quickly? > > > Are you now looking for the LIMIT ? > > SELECT * FROM table LIMIT 1; > > and when when