"D. Duccini" <[EMAIL PROTECTED]> writes:
> I think we found a way around it!
> CREATE OR REPLACE FUNCTION date_immutable( timestamptz ) RETURNS date AS
> 'SELECT date( $1 ) ;' LANGUAGE 'sql' IMMUTABLE ;
No, you just found a way to corrupt your index. Pretending that
date(timestamptz) is immutabl
Bruno Wolff III <[EMAIL PROTECTED]> writes:
> I am not sure how to check if the supplied function for converting
> a timestamp with time zone to a timestamp without timezone using a
> specified time zone is immutable. I think this function should be
> immutable, but that it probably isn't.
Yup. I
On Fri, Oct 01, 2004 at 13:28:30 -0500,
Bruno Wolff III <[EMAIL PROTECTED]> wrote:
>
> I am not sure how to check if the supplied function for converting
> a timestamp with time zone to a timestamp without timezone using a
> specified time zone is immutable. I think this function should be
> imm
On Mon, Sep 27, 2004 at 19:14:09 -0500,
"D. Duccini" <[EMAIL PROTECTED]> wrote:
>
> I'm trying to create a index from a timestamp+tz field and want the index
> to be date_trunc'd down to just the date
>
> when i try to do a
>
> create idxfoo on foo (date(footime));
>
> i get a
>
> ERROR: D
I'm at a loss to explain this one:
$ psql -v AUTHOR="'foo'" -c 'select :AUTHOR;'
ERROR: syntax error at or near ":" at character 8
$ psql -v AUTHOR="'foo'"
...
# select :AUTHOR;
?column?
--
foo
(1 row)
In other words, why won't variable interpolation work when the "-c" flag is
used?
Ugh, never mind. I finally saw the reason in the 'psql' documentation. Missed it
the first time. (And the second, and third, ...)
--
Jeff Boes vox 269.226.9550 ext 24
Database Engineer fax 269.349.9076
Nexcerpt, Inc.
