On Tuesday 02 December 2003 16:12, Franco Bruno Borghesi wrote:
> I need a function to fetch the nextval of a sequence (it should do other
> things, but my problem is the nextval() call), like this:
>
> CREATE OR REPLACE FUNCTION test() RETURNS INTEGER AS '
> DECLARE
> val INTEGER;
> BEGIN
> val:=SELECT nextval(''''''''''usuarios_seq'''''''''');
> I can't figure out how many quotes I should use to call nextval. I've
> read an article at the techdocs about this, but didn't help me. If
> anyone knows the *magic* number, please tell me :)
Two, or escape them:
nextval(''usuarios_seq'')
or
nextval(\'usuarios_seq\')
--
Richard Huxton
Archonet Ltd