From: Anibal David Acosta <anibal.acosta@edge.com.py>
To: "'Julius Tuskenis'" <julius@nsoft.lt>,
	<pgsql-admin@postgresql.org>
References: <4BA37FF5.8060001@nsoft.lt>
In-Reply-To: <4BA37FF5.8060001@nsoft.lt>
Subject: Re: insert in function writen in pgplsql
Date: Fri, 19 Mar 2010 11:00:34 -0400
Message-ID: <000f01cac774$f2d17ef0$d8747cd0$@net.py>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="utf-8"
Content-Transfer-Encoding: quoted-printable
Thread-Index: AcrHaoxupTfxJBT4Sias6ralzH5hnAACj/VQ
Content-Language: es-py

Try

function add_user(_user varchar(20), _password varchar(20))

INSERT INTO my_users(user, password) VALUES (_user, _password);


-----Mensaje original-----
De: pgsql-admin-owner@postgresql.org =
[mailto:pgsql-admin-owner@postgresql.org] En nombre de Julius Tuskenis
Enviado el: viernes, 19 de marzo de 2010 09:45 a.m.
Para: pgsql-admin@postgresql.org
Asunto: [ADMIN] insert in function writen in pgplsql

Hello

lets say I have a function add_user(user varchar(20), password=20
varchar(20)). In its body I want to have statement INSERT INTO=20
my_users(user, password) VALUES (user, password); The problem is I cant=20
- then I try to create such function I get "ERROR:  syntax error at or=20
near "$1"
LINE 1: INSERT INTO my_users(  $1 .... " This tells me the parameter is=20
used instead of column name. That is of course not what I wanted. What=20
would you recommend to fix this? Is there any way to tell the postgres=20
that user is column name? I tried "user" with same error. Must I change=20
the names of parameters?

using PG 8.3

--=20
Julius Tuskenis
Programavimo skyriaus vadovas
UAB nSoft
mob. +37068233050


--=20
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin