> I tried to use function date_part('quarter', date) in query and I have
> got wrong results...
Yeesh! Don't know what I was thinking at the time, but it sure is wrong.
If you have PostgreSQL built from source, then you can fix this by
editing src/backend/utils/timestamp.c on or around line 2056.
Anyone can help with that one?
Warning: PostgresSQL query failed: ERROR: cannot find attribute 10 of
relation pg_am in [..]
Warning: 0 is not a PostgresSQL result index in
Thanks in advice
ineck
Hello,
According to your list of supported platforms postgresql 7.0 would probably
compile on the vax port of NetBSD. Is that true?
Because i tried and couldn't really get it to work.
greetings,
bart sikkes
I don't have a bug template at hand.
Within a plpgsql function, concatenating TEXT strings from tables that allow NULL
values return nil results. Please run the following. The result of the second select
is nil.
Cheers, H.P.
---
create
Hans Peter Wuermli <[EMAIL PROTECTED]> writes:
> Within a plpgsql function, concatenating TEXT strings from tables that
> allow NULL values return nil results.
That's not a bug: NULL concatenated with anything produces NULL,
per SQL92 specification.
If you want a NULL to act like an empty string
CREATE TABLE nulltest (nullfield);
INSERT INTO nulltest VALUES (null);
pgcvs=# select (nullfield = 'willbenull') is null from nulltest;
?column?
--
t
(1 row)
pgcvs=# select (nullfield = 'willbenull') is true from nulltest;
?column?
--
(1 row)
pgcvs=# select (nullfield = 'w
"Robert B. Easter" <[EMAIL PROTECTED]> writes:
> The IS operator is supposed to return only TRUE or FALSE, never NULL. See
> ISO/IEC 9075-2:1999 6.30
Yeah, we do not implement IS TRUE, IS FALSE, etc per spec. IS [NOT] NULL
is the only one of the group that works per-spec; the others all
er
On Saturday 06 January 2001 17:56, Tom Lane wrote:
> "Robert B. Easter" <[EMAIL PROTECTED]> writes:
> > The IS operator is supposed to return only TRUE or FALSE, never NULL.
> > See ISO/IEC 9075-2:1999 6.30
>
> Yeah, we do not implement IS TRUE, IS FALSE, etc per spec. IS [NOT] NULL
> is the o
Simple add lines as shown:
> for r in select * from tconcattest loop
IF r.str IS NOT NULL THEN
> output := output || r.str;
END IF;
> end loop;
- Andrew
