-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hello,
I was trying to create a functional index on a timestamptz column and
had the following problem. It seems subraction of an interval from a
timestamptz is not immutable. Should this be the case?
foo=> create table timestamp_tz_test ( start tim
Hello,
I noticed in plpgsql that a semi colon is not always required after
the END statement. A contrived example:
CREATE sequence foo;
CREATE OR REPLACE FUNCTION bar() RETURNS VOID AS '
DECLARE
bar int;
BEGIN
SELECT INTO bar nextval(''foo'');
RETURN;
END
' LANGUAGE plpgsql;
--hussein
Hello,
I noticed in plpgsql that a semi colon is not always required after
the END statement. A contrived example:
CREATE sequence foo;
CREATE OR REPLACE FUNCTION bar() RETURNS VOID AS '
DECLARE
bar int;
BEGIN
SELECT INTO bar nextval(''foo'');
RETURN;
END
' LANGUAGE plpgsql;
--hussein
