-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Michael Fuhr wrote: | On Fri, Apr 22, 2005 at 03:31:59AM +0100, Carlos Correia wrote: | |>Michael Fuhr wrote: |>| On Fri, Apr 22, 2005 at 01:44:24AM +0100, Carlos Correia wrote: |>| |>|>carlos=# insert into test (c1) values( 'test'); |>|>ERROR: NEW used in query that is not in a rule |>|>CONTEXT: PL/pgSQL function "tftest" line 2 at perform |>| |>| PostgreSQL 8.0 and later have improved support for composite types. |> |>Thanks... but does this means that you can't do that with version 7.4.x? | | | Not as far as I know, or at least not the same way. |
Well... I guess I'll have to do it the hard way (no big deal)
Thank you very much ;-)
Carlos - -- MEMÓRIA PERSISTENTE, Lda. Tel.: 219 291 591 - GSM: 967 511 762 e-mail: geral@xxxxxxxx - URL: http://www.m16e.com AIM: m16e - ICQ: 257488263 - Jabber: m16e@xxxxxxxxxxx Skype.com username (VoIP): m16e.com -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.0 (GNU/Linux) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
iD8DBQFCaXOQ90uzwjA1SJURAq8FAJ9Bz+NZpjdG3Ig3QaFXyMGY0JNs2wCaAmNy InMlLAsINv/mEBCDtt6YWwc= =2NMd -----END PGP SIGNATURE-----
---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match