- Original Message -
From: "Tom Lane" <[EMAIL PROTECTED]>
Newsgroups: comp.databases.postgresql.bugs
Sent: Wednesday, September 03, 2003 1:05 AM
Subject: Re: to_timestamp not stable if date string shorter than template
> "Stacy White" <[EMAIL PROTECTED]> writes:
> > to_timestamp appears
Hi all,
running on Postgres 7.3.3
I seen that cast a integer to an intervall is not permitted
select 0::interval;<- give error
but
select 0::text::interval; <- works fine
but I notice that the following function return correctly
doing the integer -> interval cast in one "shot":
create or
"Tom Lane" <[EMAIL PROTECTED]> wrote:
> "Mendola Gaetano" <[EMAIL PROTECTED]> writes:
> > #\d t_a
> > Table "public.t_a"
> > Column | Type | Modifiers
> > +-+---
> > a | integer |
&
On: Sunday, July 13, 2003 4:19 AM "Tom Lane" <[EMAIL PROTECTED]> wrote:
> "Mendola Gaetano" <[EMAIL PROTECTED]> writes:
> > the function is immutable but is executed 3 times
> > ( one for each row).
>
> So? Sounds to me like it's work
Hi all,
I'm running the followin example on Postgres 7.3.3
I notice that if I declare an immutable function like this:
CREATE OR REPLACE FUNCTION test (integer) RETURNS integer
AS '
declare
begin
raise notice ''test called'';
return $1+1;
end;'
LANGUAGE plpgsql IMMUTABLE;
and I use this func
Hi all,
I have a DB with encoding SQL_ASCII and in some field I have strange
character:
# \encoding
SQL_ASCII
# select city, id_country from user_data where id_user = 4146;
city| id_country
---+
Serra de Outes - A Coruña | 61
(1 r
