Re: plpgsql mixing variable in SELECT INTO ?

Поиск
Список
Период
Сортировка
От Jean-Luc Lachance
Тема Re: plpgsql mixing variable in SELECT INTO ?
Дата
Msg-id 3E6504D5.46B48790@nsd.ca
обсуждение исходный текст
Ответ на plpgsql mixing variable in SELECT INTO ?  ("Ben-Nes Michael" <miki@canaan.co.il>)
Список pgsql-general
Maybe he is looking at a shorthand for assigning a row variable to an
other...



Tom Lane wrote:
>
> "Ben-Nes Michael" <miki@canaan.co.il> writes:
> > You mean I cant use the full power of the SELECT as mentioned in the manual
> > and when using SELECT INTO I must use * and I can refine my query to some of
> > the fields ?
>
> Certainly you can.  But when you assign into a row variable, you have to
> provide all the row variable's columns, in order.  How else would you
> expect it to work?
>
> > Also its quite strange that my code worked in 7.3.1-
>
> I don't believe it.
>
>                         regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly

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

Предыдущее
От: "Greg Sabino Mullane"
Дата:
Сообщение: Mailing lists still points to a non-existent page
Следующее
От: reece@in-machina.com
Дата:
Сообщение: psql \pset pager always for 7.3.2 (patch)