Re: select query of mysql to postgres

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: "Burgholzer, Robert (DEQ)" <Robert(dot)Burgholzer(at)deq(dot)virginia(dot)gov>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: select query of mysql to postgres
Date: 2015-06-26 13:22:15
Message-ID: CAKFQuwZ5seDpe2hk_Pu-r1duaJ8VsU7fq2sU6zJybwX9b2Dk9Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Fri, Jun 26, 2015 at 7:58 AM, Burgholzer, Robert (DEQ) <
Robert(dot)Burgholzer(at)deq(dot)virginia(dot)gov> wrote:

> So this seems to be saying that postgres does not have the ifnull
> function:
> http://www.postgresql.org/docs/9.2/static/functions-conditional.html
> http://www.postgresql.org/docs/9.2/static/functions-conditional.html
>
>
The function that performs equivalently is "COALESCE"

David J.​

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message sam turnbull 2015-06-26 13:31:08 Restore backup of database to new database name
Previous Message Ankur Kaushik 2015-06-26 12:27:13 Re: select query of mysql to postgres