Re: [SQL] Using a rule as a trigger.

2001-01-10 Thread Tulio Oliveira
Andrew Higgs wrote: > > Hi all, > > I have looked at some previous posting and thought that I had found > exactly what I need. What I need is to insert an id (from a sequence) > when a new record is inserted. The following example almost does what I > need : > > CREATE TABLE topics (id int, to

Re: [SQL] substring ..

2000-12-19 Thread Tulio Oliveira
Jeff MacDonald wrote: > > hi folks.. > > i want to do this to a datetime field.. > > select foo from table where substr(datefoo,1,11) = '2000-12-14'; > > it returns no results yet.. > > select substr(datefoo,1,11) does return some values that say > 2000-12-14 > > any clues ? > > Jeff MacDon

[SQL] Compiling "C" Functions

2000-12-14 Thread Tulio Oliveira
k... I can“t even compile them... Please, anyone could help an "poor brazilian guy" to make this work :-) ? I appreciate any "C" Function complete samples, including de command line for the compiler. I using a RedHat Linux 6.2 and P