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
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'.
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
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
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
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
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
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
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
ಇಂಡ್ಲಿನಕ್ಸ வாழ்க!
---
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
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
11 matches
Mail list logo