Thread: Rules

Hi,

What i am trying to do is

i have a join table eg

primarykey
field1
field2

and based on SQL Select have the values of field1 inserted into a new
table which will scroll which will launch a trigger but im having
problems getting this to work? Any ideas anyone?

sql select may return 1 or more results so i will 1 insert statements

On Mon, Dec 06, 2004 at 04:15:54PM +1100, Jamie Deppeler wrote:

> i have a join table eg
>
> primarykey
> field1
> field2
>
> and based on SQL Select have the values of field1 inserted into a new
> table which will scroll which will launch a trigger but im having
> problems getting this to work? Any ideas anyone?

I'm not sure I follow.  Could you post examples of what you've
tried, describe what you want to happen, and tell us what actually
did happen?

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

Hi,

someone has successfully migrated a database from
informix to postgresql?

there are any tools that helps or maybe an script?

regards,
Jaime Casanova

_________________________________________________________
Do You Yahoo!?
Información de Estados Unidos y América Latina, en Yahoo! Noticias.
Visítanos en http://noticias.espanol.yahoo.com