Postgres Pro
Downloads
Home   >   mailing lists

Re: Why does this work? - Mailing list pgsql-general

From Rodrigo De León
Subject Re: Why does this work?
Date
Msg-id 1181935965.951553.93250@w5g2000hsg.googlegroups.com
Whole thread Raw
In response to Why does this work?  ("Ian Harding" <harding.ian@gmail.com>)
List pgsql-general
Tree view 
On Jun 15, 1:56 pm, harding....@gmail.com ("Ian Harding") wrote:
> I accidentally formatted a string for tsearch before trying to cast it
> to a date, and it worked!
>
>  select 'June&15&2007'::date
>     date
> ------------
>  2007-06-15
> (1 row)
>
> Is this a happy accident, or is it OK to count on it continuing to
> work this way?
>
> Thanks,
>
> Ian

select
'June&15&2007'::date
,'June.15.2007'::date
,'June__15__2007'::date

See: http://www.postgresql.org/docs/8.2/static/x71171.html

pgsql-general by date:

Previous
From: "guillermo arias"
Date:
Subject: is it possible to recover more than one recordset or cursor from a function?
Next
From: Steve Crawford
Date:
Subject: Re: is it possible to recover more than one recordset or cursor from a function?