Ok, this should be simple. How do I find the defined maximum
length of a varchar field?
--
http://dating.blameitonlove.com/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Sunday 20 July 2008, Robert Urban <[EMAIL PROTECTED]> wrote:
> Hi PostgreSQLer,
>
> if I have a table, the_table, with a DATE field, i'll call it 'day', and
> I'd like to find all rows whos day falls within a given month, which of
> the following methods is faster/costs less:
>
> 1.
>
> SE
am Sun, dem 20.07.2008, um 20:08:21 +0200 mailte Robert Urban folgendes:
> Hi PostgreSQLer,
>
> if I have a table, the_table, with a DATE field, i'll call it 'day', and
> I'd like to find all rows whos day falls within a given month, which of the
> following methods is faster/costs less:
>
> 1
Hi PostgreSQLer,
if I have a table, the_table, with a DATE field, i'll call it 'day', and I'd
like to find all rows whos day falls within a given month, which of the
following methods is faster/costs less:
1.
SELECT * FROM the_table WHERE day LIKE '2008-01-%';
2.
SE
Hello
2008/7/20 Suresh <[EMAIL PROTECTED]>:
> Hello,
>
> Version is 8.1.3. Its an older version, in which I have some custom code.
> I want to test the code with a function which has a seq scan and a blocking
> loop.
>
first, scrollable cursors are supported from 8.3
second, you cannot declare cu
Hello,
Version is 8.1.3. Its an older version, in which I have some custom code.
I want to test the code with a function which has a seq scan and a blocking
loop.
Thanks,
Suresh
--- On Sun, 7/20/08, Pavel Stehule <[EMAIL PROTECTED]> wrote:
From: Pavel Stehule <[EMAIL PROTECTED]>
Subject: Re: [G
Hello
what is version of your postgresql?
regards
Pavel Stehule
2008/7/20 Suresh_ <[EMAIL PROTECTED]>:
>
> I get this error
>
> ERROR: syntax error at or near "cursor"
> CONTEXT: invalid type name "scroll cursor for select * from tpcd.customer"
> compile of PL/pgSQL function "udf" near line 5
