[SQL] unsuscribe

2005-10-27 Thread Ing. Jhon Carrillo-Venezuela
unsuscribe ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly

[SQL] unsubscribe

2005-06-01 Thread Ing. Jhon Carrillo - Caracas, Venezuela
unsubscribe ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Re: [SQL] Replacing a table with constraints

2005-05-13 Thread Ing. Jhon Carrillo
Use  Drop table YOUR_TABLE cascade   Jhon CarrilloIngeniero en ComputaciónCaracas - Venezuela     - Original Message - From: Mark Fenbers To: pgsql-sql@postgresql.org Sent: Friday, May 13, 2005 2:38 PM Subject: [SQL] Replacing a table with constraints I h

[SQL] Function .. AS..?

2005-02-09 Thread Ing. Jhon Carrillo
Those instructions are good but i want  to call this function  only  for  " select  consulta_contacto(1)"  nothing more,  Is really necesary to use  "AS ..."?   this is  the call:     select * from  consulta_contacto(1) as (cont_codigo  integer,    

[SQL] error in function!!

2005-01-31 Thread Ing. Jhon Carrillo
Hi,   i have a problem  with the following sentence:     CREATE OR REPLACE FUNCTION tschema.sp_actualizar_contacto(p_idpers text,  p_nombre text,  p_apellido text,