[SQL] Range of caracters

2007-08-07 Thread Wilton Wonrath
Hello, I have a doubt about a query using a range of caracters. Example: Data Table Inicial - Final 9C2HB02107R008000 9C2HB02107R008200 FAIXA1FAIXA100 I´m doing the

[SQL] Postgresql number of command

2005-01-31 Thread Wilton
telefone set numero = '-'; Thanks, and sorry if it´s not here to put the message... just say me where i need to write this question... Thank you very much Wilton Ruffato Wonrath -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.300 / Viru

[SQL] Function Doubt

2005-01-27 Thread Wilton
nsert = StrInsert || virgula || StrCampo || '' - ''; End Loop; Return new; End; What i need to do for the variable StrCampo returns to me "SP", "RJ", i mean, return a value inserted into the field. I do not want to use static command new.campo1, new.campo2.

Re: [SQL] Complete instruction in a trigger

2005-01-27 Thread Wilton
update just for that column. But i do not know in which column his has made that change. So, i need to know the instruction to do this. Something like a specific update for that column modified by the user. Thanks very much. Wilton Ruffato Wonrath No virus found in this outgoing message. Check

[SQL] Complete instruction in a trigger

2005-01-27 Thread Wilton
Hi... People, i wanna know how can i know inside of a function whar the trigger called, i mean which instruction SQL it called. I do not wanna know if it´s a insert, update or delete (tp_op), i need to know the complete instruction. For example, i need to know something like this: update phones