On 17 August 2016 at 11:33, Vince Vielhaber <v...@chives.michvhf.com> wrote:

> I recently moved a mybb forum away from mysql to postgres.  Along the way
> I encountered a couple of things that either didn't seem to be supported or
> I'm just not doing it right. First, the server this is on is running
> version 8.4.22
8.4 is end-of-life, so it's time to move.

FYI, this isn't really the right place for these questions; pgsql-general
or Stack Overflow is more appropriate for topics not relating to PostgreSQL
code and design.

#1 Are joins supported in deletes?  The same join syntax works fine as
> a select.

Yes, but the syntax is a bit different and you can't use aliases on the
target table. You can also (unfortunately) only do inner joins.

> #2 is extract supported in a select statement dealing with a table?  To
> explain this one, here is the error I get:

If 'dateline' is an integer, you'll have to turn it into a timestamp or
date before you can extract the epoch.

> # select extract(epoch from timestamp dateline::timestamp) from
> mybb_adminlog limit 1;

You can't use the typed-literal syntax

TIMESTAMP 'something'

for a column reference, bind-parameter, etc. You can only use it for
literals. Use a CAST or the PostgreSQL :: shorthand. Just remove the
"timestamp" from "FROM timestamp".

Doesn't matter if I use epoch or day or anything else, they all fail with
> the same error.  And yes, dateline is a timestamp.

No, it isn't. The error message says so.

Please use pgsql-general or Stack Overflow.

 Craig Ringer                   http://www.2ndQuadrant.com/ PostgreSQL
Development, 24x7 Support, Training & Services

Reply via email to