Re: [SQL] error: cast the timestam expression

2005-01-28 Thread Tom Lane
friendVU admin <[EMAIL PROTECTED]> writes: > When I execute this: > "insert into comments > ( > date_posted > ) > (select date_published > from xyz > )" > I get : > "ERROR: column "date_posted" is of type timestamp without time zone but > expression is of type tex

Re: [SQL] error: cast the timestam expression

2005-01-28 Thread Michael Glaesemann
On Jan 28, 2005, at 23:55, friendVU admin wrote: When I execute this: "insert into comments ( date_posted ) (select date_published from xyz )" I get : "ERROR: column "date_posted" is of type timestamp without time zone but expression is of type text HINT: You will need to