Re: Migration from DB2 to PostgreSQL

From: Chris Angelico <rosuav(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Migration from DB2 to PostgreSQL
Date: 2013-06-20 02:10:56
Message-ID: CAPTjJmqnRs7fGxeby4TB2ohiwUW=pz58-5w9NRNQEr09RnEcCA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Jun 20, 2013 at 12:09 PM, Amit Langote <amitlangote09(at)gmail(dot)com> wrote:
> Umm, my bad! I almost forgot I could write pure SQL function bodies.
> Although, why does following happen? (sorry, a 8.4.2 installation) :
>
> postgres=# create or replace function gt(n int, m int) returns boolean
> as 'select n>m' language sql;
> ERROR: column "n" does not exist
> LINE 2: as 'select n>m' language sql;

Hmm, no idea. I'm using 9.2.4, could well have been changes.

ChrisA

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Amit Langote 2013-06-20 02:34:06 Re: Migration from DB2 to PostgreSQL
Previous Message Amit Langote 2013-06-20 02:09:14 Re: Migration from DB2 to PostgreSQL