On 9/5/06, codeWarrior <[EMAIL PROTECTED]> wrote:
It's generally considered bad form to use reserved words as column names....
I am aware of that - in this case the column names are chosen to
reflect exactly the names of the attributes of the event being
recorded.
""Frank Church"" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
>I am trying to create a view based on this query
>
> 'select *, "timestamp"::timestamp from ccmanager_log'
>
>
> This is the error I get to below, how do I use the time zone syntax
>
> error: cannot cast tupe double precision to timestamp without time zone
>
> What is the right syntax?
>
>
> The column to be converted is also called timestamp
>
> F Church
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match
>
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
