am 25.04.2006, um 14:03:07 +0200 mailte Mario Splivalo folgendes: > > And then, when I want to fill in the type_var, i do this: > > type_var.member_a := col_a FROM table_a WHERE col_c = 5; > type_var.member_b := col_b FROM table_a WHERE col_c = 5; > > Is there a way to fill in the type_var, but from just one statement? > Here I have two 'selects' on table_a, and that seems as bit expensive > when iterated a lot of times. > > I guess I could do: > SELECT col_a, col_b INTO type_var.member_a, type_var.member_b FROM > table_A WHERE col_c = 5; > > but that is a bit hard to read :) > > Are there more options on doing what I'd like to do?
select into type_var col_a, col_b from table_a ... ; HTH, Andreas -- Andreas Kretschmer (Kontakt: siehe Header) Heynitz: 035242/47215, D1: 0160/7141639 GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net === Schollglas Unternehmensgruppe === ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
