Re: named parameters in SQL functions

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: "David E(dot) Wheeler" <david(at)kineticode(dot)com>
Cc: Greg Stark <gsstark(at)mit(dot)edu>, Andrew Chernow <ac(at)esilo(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: named parameters in SQL functions
Date: 2009-11-15 19:39:04
Message-ID: 4B0058D8.6040102@dunslane.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

David E. Wheeler wrote:
>
> $foo should be killed off as a valid identifier, IMNSHO.
>
>
>

It's only legal when quoted. Unquoted indetifiers can't begin with $.
see scan.l:

ident_start [A-Za-z\200-\377_]
ident_cont [A-Za-z\200-\377_0-9\$]
identifier {ident_start}{ident_cont}*

cheers

andrew

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Simon Riggs 2009-11-15 19:43:39 Re: Summary and Plan for Hot Standby
Previous Message Greg Stark 2009-11-15 19:38:25 Re: Summary and Plan for Hot Standby