Re: Migration from DB2 to PostgreSQL - Mailing list pgsql-general

From Chris Angelico
Subject Re: Migration from DB2 to PostgreSQL
Date
Msg-id CAPTjJmqnRs7fGxeby4TB2ohiwUW=pz58-5w9NRNQEr09RnEcCA@mail.gmail.com
Whole thread Raw
In response to Re: Migration from DB2 to PostgreSQL  (Amit Langote <amitlangote09@gmail.com>)
Responses Re: Migration from DB2 to PostgreSQL  (Amit Langote <amitlangote09@gmail.com>)
List pgsql-general
On Thu, Jun 20, 2013 at 12:09 PM, Amit Langote <amitlangote09@gmail.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


pgsql-general by date:

Previous
From: Amit Langote
Date:
Subject: Re: Migration from DB2 to PostgreSQL
Next
From: Amit Langote
Date:
Subject: Re: Migration from DB2 to PostgreSQL