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
Hi,
I have a couple questions, I am tryingto write a function that
takes as input a list (size being dynamic) of primaryIDKeys, along with
a userdefined type and returns a set of rows containing those keys.
Furthermore the rows are exactly (columns) like the table that contains
the keys, but has
