Re: [SQL] Mac Address

[Andreas Kretschmer]

Ezequias Rodrigues da Rocha <[EMAIL PROTECTED]> schrieb:

> Hi list,
> 
> It is possible to retrieve the MAC Address of a computer using a Postgresql
> function like others:

In the same subnet? Then you can use untrusted languages such as plperlu
or plsh to retrieve the MAC for a IP. (arp -a ip)

Btw.: please no HTML in eMails.


HTH, Andreas
-- 
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect.  (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly."(unknow)
Kaufbach, Saxony, Germany, Europe.  N 51.05082°, E 13.56889°

---(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

Re: [SQL] How to get the row that start a trigger

[Aaron Bono]

On 8/31/06, Ezequias Rodrigues da Rocha <[EMAIL PROTECTED]> wrote:
Hi,I need make a trigger that update a table each time another table has a insert. but this insert has on this row all the items to pass to my function on the trigger.How to retrieve this information.
 See the example at the end of the page http://www.postgresql.org/docs/8.1/interactive/triggers.html - how it uses the OLD and NEW implicit variable.  You can use 
NEW.column_name to access the data being inserted into the table.Does this help?==   Aaron Bono   Aranya Software Technologies, Inc.
   http://www.aranya.com   http://codeelixir.com==