Could anyone confirm that the returned value from the function below behaves the same way as MS SQL Server @@SPID variable and that it remains unchanged and unique throughout a connection ?
create function getpid() returns int as '/bin/cygwin1.dll' language 'c';