I am still unclear of how this works. Please help! I really would appreciate this. This is what I have so far:
CREATE TYPE tp_lm_object AS(
.
);
CREATE OR REPLACE FUNCTION
getLMs(int[],float(8), float(8)) RETURNS SETOF tp_lm_object AS $$
DECLARE
myrec record;
requestIds
Hi,
Here is an example
Regards
/David
CREATE OR REPLACE FUNCTION
usp_Inventaire_Transaction_Statut_Changer(int[], varchar, int, date)
RETURNS INTEGER AS '
DECLARE
requestIds ALIAS FOR $1;
companyId ALIAS FOR $2;
targetStatus ALIAS FOR $3;
transactionDate ALIAS FOR $4;
transactionDate_ timest
Assad Jarrahian <[EMAIL PROTECTED]> writes:
> How do you take in a list of int?
Use an array.
regards, tom lane
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an i
On Tuesday 07 June 2005 16:16, Bob wrote:
> What are the opinions on a separate list just for pl/pgsql? Seems pl/pgsql
> deserves her own area. Just wondering if this would make sense, and if it
> did can we have a separate list?
FWIW, a good number of posts in the pgsql-sql list actually referenc
When the list traffic demands it, perhaps it'll be considered. Until
then there's no reason to multiply lists beyond necessity. Even Tom
Lane has an upper limit on the number of lists he can read each day. :)
Since when?
;)
-Doug
---(end of broadcast)---
Bob <[EMAIL PROTECTED]> writes:
> My thought is on it's own pl/pgsql is just as important as straight SQL.
> Maybe as time goes on we will see higher volumes of pl/pgsql questions, if
> that is what warrants a separate list. I personally don't see why one
> would put pl/pgsql in with everything e
My thought is on it's own pl/pgsql is just as important as straight SQL. Maybe as time goes on we will see higher volumes of pl/pgsql questions, if that is what warrants a separate list. I personally don't see why one would put pl/pgsql in with everything else. Maybe because I come from an Oracle
[EMAIL PROTECTED] (Bob) writes:
> What are the opinions on a separate list just for pl/pgsql? Seems
> pl/pgsql deserves her own area. Just wondering if this would make
> sense, and if it did can we have a separate list?
I haven't been seeing so much traffic about pl/pgsql that it seems to
warrant
Bob <[EMAIL PROTECTED]> writes:
> What are the opinions on a separate list just for pl/pgsql? Seems
> pl/pgsql deserves her own area. Just wondering if this would make sense,
> and if it did can we have a separate list?
I don't think it makes sense--it's not like traffic related to
pl/pgsql floo
