insert in function writen in pgplsql
От | Julius Tuskenis |
---|---|
Тема | insert in function writen in pgplsql |
Дата | |
Msg-id | 4BA37FF5.8060001@nsoft.lt обсуждение исходный текст |
Ответы |
Re: insert in function writen in pgplsql
Re: insert in function writen in pgplsql Re: insert in function writen in pgplsql |
Список | pgsql-admin |
Hello lets say I have a function add_user(user varchar(20), password varchar(20)). In its body I want to have statement INSERT INTO my_users(user, password) VALUES (user, password); The problem is I cant - then I try to create such function I get "ERROR: syntax error at or near "$1" LINE 1: INSERT INTO my_users( $1 .... " This tells me the parameter is used instead of column name. That is of course not what I wanted. What would you recommend to fix this? Is there any way to tell the postgres that user is column name? I tried "user" with same error. Must I change the names of parameters? using PG 8.3 -- Julius Tuskenis Programavimo skyriaus vadovas UAB nSoft mob. +37068233050
В списке pgsql-admin по дате отправления: