var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Which is the preferred way to call a function?
I'm migrating some procs from Sybase. That's a treat in itself. I've finally got the proc to return the same data.
What I'm now wondering (and don't know the answer to) is: What is the preferred way to call the proc?
In sybase, you'd do:
For postgresql, I can do this:
exec sp_procNameHere 'foo', 'bar'
select sp_procNameHere('foo', 'bar')
which is correct/best (and why?)
select * FROM sp_procNameHere('foo', 'bar')
Both will work. The second format was designed for functions that return records or sets of records. I generally use the first format. And if you want to explode the tuple returned from a function you can also do this
my proc from sybase returns a table of data. I think in postgreSQL (PG?) this is referred to generally as 'sets' ?
What does "explode the tuple" mean?