Hi
I have problem calling my function (prety easy):
== sql begin ==
CREATE OR REPLACE FUNCTION "InventGroups_GetAllParents"(int8)
RETURNS SETOF "ItemGroupRelationNode" AS
$BODY$declare
R RECORD;
SR RECORD;
begin
FOR R IN select ItemGroupId, ParentItemGroupId
;
> On Jan 19, 2006, at 21:39 , Juris wrote:
>
> > == sql begin ==
> > CREATE OR REPLACE FUNCTION "InventGroups_GetAllParents"(int8)
>
> > select * from InventGroups_GetAllParents(0::int8)
> > ===
> > ERROR: function inventgroups_getallparents(bigi
Jep... but pgAdmin_III inserts dbl-quotes, if there is some
CamelCase... but from sql-console i can create objects w/ or w/o
dbl-quotes, but in result i always get lower-cased objects..
Seems, i should `recreate` my db in lowercase.. it will take some time :(
Thanks for advance.
PS: problem he
Create view/storedproc on pg_class & pg_attribute tables
2006/2/16, AKHILESH GUPTA <[EMAIL PROTECTED]>:
> hi all,
> i just want to know one thing that is there any function in PGSQL which
> gives me the total number of columns in a table.
> OR
> just like we are using count(*), it gives us to
For SQL-passwords usually use hashes...
2006/5/30, Penchalaiah P. <[EMAIL PROTECTED]>:
Hello,
I want to create a table with an encrypted field for a password entry, so
that you can see only .
And can I encrypt fields which datatype is an integer or a timestamp?
Hi pls let me know th
Hello!
i have problem with pl/pgsql function;
===
ERROR: wrong record type supplied in RETURN NEXT
CONTEXT: PL/pgSQL function "tests" line 6 at return next
===
-- Function: tests(int8)
-- DROP FUNCTION tests(int8);
CREATE OR REPLACE FUNCTION te
Solved
John DeSoi wrote:
On Mar 11, 2005, at 5:54 AM, Juris Zeltins wrote:
FOR P IN select pageid from pages
This way you are only getting the pageid column. I think what you want is
FOR P in select * from pages
so that P contains the complete pages record.
John DeSoi, Ph.D.
http://pgedit.com/
