Hello,
I need a type that will store date and time, but without seconds and
microseconds (like timestamp does). At least without microseconds.
I also need all the operators to work.
Is this possible with one of existing date/time types or i need to create my
own?
Thank you!
...order by currency not in('USD', 'AND', 'CAD');
this condition will be avaluated as FALSE for USD, AND and CAD, and as TRUE
for all other currencies. When the records are sorted the "false" are placed
on the top because false wrote:
> Good morning,
>
> I have a currency table (code, description
Hello!
I'm trying to run this code in one of my stored procedures
s := 'execute prepared_plan( ' || id_engine || ',' || id_search || ',' ||
id_rsite || ')';
execute s;
where "prepared_plan" is a statement defined before with PREPARE.
The thing is, that if i one of the parameters is NULL, then
Hello!
Can anyone tell me how i do this properly?
create or replace function agg(varchar,varchar) returns void as $func$
select $1,count(*) from $2 group by $1 order by $1;
$func$
Language SQL;
Right now this wives me "ERROR: syntax error at or near "$2" at character
97
select $1,count(*
