Re: variable substitution in SQL commands

Поиск
Список
Период
Сортировка
От bill house
Тема Re: variable substitution in SQL commands
Дата
Msg-id 4B664A19.70805@bellsouth.net
обсуждение исходный текст
Ответ на Re: variable substitution in SQL commands  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: variable substitution in SQL commands  (bill house <wchouse@bellsouth.net>)
Список pgsql-novice
Tom Lane wrote:
> bill house <wchouse@bellsouth.net> writes:
>> I am trying to learn how to construct SQL commands using information
>> derived from other SQL commands/querys.
>> These commands are stored for the moment in a simple text file which
>> would be executed by the psql client like so:
>>     current_database=# \i sql_command_file.sql
>
> This is really getting beyond what you can do usefully with a simple
> psql text file.  My first suggestion would be to see if you can write
> what you need as a plpgsql function.
>
>             regards, tom lane
>

I was afraid you were going to say that.  This was the indication that I
was getting from my reading, but I just wanted to make sure this trip
was really necessary.

Thanks,

Bill House

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: variable substitution in SQL commands
Следующее
От: Neil Stlyz
Дата:
Сообщение: combine SQL SELECT statements into one