How to use parameters in stored procedures?

Поиск
Список
Период
Сортировка
От Cyphos
Тема How to use parameters in stored procedures?
Дата
Msg-id 1137174809.411619.194260@f14g2000cwb.googlegroups.com
обсуждение исходный текст
Ответы Re: How to use parameters in stored procedures?  (Michael Fuhr <mike@fuhr.org>)
Список pgsql-general
Hi guys,

I'm very new to PostgresSQL, coming from MS SQL. I'm trying to write a
function that will select a row from a location:

CREATE FUNCTION SelectLocation(IN "myLocationID" int4) RETURNS
"Location"
LANGUAGE 'sql' AS
$BODY$
SELECT
    "LocationID",
    "Name",
    "PhoneNumber",
    "FaxNumber",
    "EmailAddress",
    "StreetAddress",
    "City",
    "Province",
    "PostalCode"
FROM "Location"
WHERE "LocationID" = "myLocationID"
ORDER BY "Name";
$BODY$

I get an error that the column myLocationID doesn't exist. I'm sure
it's something simple, but I can't figure it out.

Also too, why do I have to quote columns and tables?

Thanks guys,
Mike


В списке pgsql-general по дате отправления:

Предыдущее
От: conexion_electronica
Дата:
Сообщение: migrar
Следующее
От: "rlee0001"
Дата:
Сообщение: Re: PostgreSQL Top 10 Wishlist