Hi, Juris,
Juris wrote:
> Seems, i should `recreate` my db in lowercase.. it will take some time :(
Maybe you can modify it "inplace" using
ALTER TABLE "OldName" RENAME TO newname;
This might even be scripted, select * from pg_tables where
schemaname='your schema' gives a list of all table
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
On Jan 20, 2006, at 1:45 , Leif B. Kristensen wrote:
That is usual behaviour for RDBMSes. They are case-insensitive if you
use ALL_CAPS or small_letters only.
PostgreSQL is case-insensitive in the sense that it down-cases
identifiers that are not double-quoted, e.g.,
MYSUPERFIELD -> mysup
On Thursday 19 January 2006 14:06, Juris wrote:
>Argh... big thanks.. did not know what pgAdmin/PG have any
>case-sensitive issues with functions...
>
>Also for fields it is relative... without dbl-quotes i could not query
>anything (i am using "MySuperField"-like field names)
That is usual behavi
Argh... big thanks.. did not know what pgAdmin/PG have any
case-sensitive issues with functions...
Also for fields it is relative... without dbl-quotes i could not query
anything (i am using "MySuperField"-like field names)
2006/1/19, Michael Glaesemann <[EMAIL PROTECTED]>:
>
> On Jan 19, 2006, a
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(bigint) does not exist
HINT: No function matches the given name and ar
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
