Naming functions with reserved words

From: Scott Bailey <artacus(at)comcast(dot)net>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Naming functions with reserved words
Date: 2009-06-17 08:46:13
Message-ID: 4A38AD55.3000708@comcast.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I noticed in the temporal project they used reserved words for their
functions (union, intersect, etc)

But when I try to create a function like that I get an error and I have
to quote it both when creating the function and when calling it. The
only difference I can see is they their functions are written in C and
mine are in SQL. But that doesn't make sense why you could do it in one
language and not in another.

What am I missing? And if it can be done, is there a strong preference
in the community about whether it should be the reserved word or follow
PostGIS's tack and prepend something to all of the functions like
ts_union and ts_intersect?

Scott

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Kellerer 2009-06-17 11:15:57 Re: Data merging problem
Previous Message Ivan Sergio Borgonovo 2009-06-17 08:41:18 simulating high load for vacuum full