Hi all:
I have Postgres 6.5.3 installed on Linux... well, sort of. The problem
is that the installation in question must be screwed up somewhere,
because I can't find the "numeric" type in it (while I can find it in
another clean 6.5.3 install), and now I need it for a project. My
questio
Marc Tardif wrote:
>
> I recommend you read Momjian's online book, very informative and provides
> all the necessary information about using various kinds of id's:
> http://www.postgresql.org/docs/aw_pgsql_book/index.html
In glancing at Momjian's stuff on this just now, I noticed the book
could
We're a small startup company with several projects
at the brink of deployment. When I say deployment, I'm talking
potentially thousands/100 thousands of users with lots of concurrent
connections to the database. Currently we use Oracle, but for the
level we need we're talking *obscene
> Peter Eisentraut wrote:
>
>
> This is a really stu^H^H^H bad idea. I have hierarchies 5 levels deep
> with
> multiple inheritance, and I
> don't want to do a 10 way join just to retrieve an object.
>
> This is why RDBMS's performance sucks so incredibly badly on some
> applications.
> an ODBM
I recommend you read Momjian's online book, very informative and provides
all the necessary information about using various kinds of id's:
http://www.postgresql.org/docs/aw_pgsql_book/index.html
As for referential integrity using foreign keys, you can add this
functionality to postgresql using tr
Take a look at Bruce's book at http://www.postgresql.org/docs/awbook.html
He explains oid's and sequences extremely well, and that might be what you
are looking for.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of sheila bel
Sent: Friday, February 04,
I think there is no maximum on the actual query length, but there is a
limit on the max row size. If I remember correctly, there is an 8k limit
to the contents of an entire row. If you need more than that, either split
your data across multiple rows are use the blob data type.
Marc
On Fri, 4 Feb
sheila bel wrote:
>
> Hi,
>
> I'm new to data base design so please bare with me if my
> question is so basic..
> I'm designing a database, two of the tables are EMPLOYEES and
> AGENCIES. I need an ID for each of them. I would also need to
> have the agencyID in the EMPLOYEES table so that I can
search for oid and serial or sequence, referential or foreign key
in the doc or archive of this list. there are a lot lot very good
advices.
On Fri, 4 Feb 2000, sheila bel wrote:
> Hi,
>
> I'm new to data base design so please bare with me if my
> question is so basic..
> I'm designing a dat
Hi,
I'm new to data base design so please bare with me if my
question is so basic..
I'm designing a database, two of the tables are EMPLOYEES and
AGENCIES. I need an ID for each of them. I would also need to
have the agencyID in the EMPLOYEES table so that I can identify
which agency they belong
create function money(float8) returns money as '
declare
f2 float8;
m money;
i2 int2;
i1 int4;
txt text;
begin
if $1 isnull then
return NULL;
end if;
--integer part...
i1:= dtrunc($1);
-- decimal part..
Hi,
Can anyone tell me whether there is a maximum query length using 'insert'?
We want to insert a text statement into our db. This statement may be up to
20k in size.
Dean
Hello All,
I have a following problem. I have a tables and fields whith names,
consisting of cyrillic characters and getting an error. When I am
doing the same things but with only english characters, everything ok.
All other things works properly, only pl/pgsql functions. Does anybody
knows how
Hello All,
create function round_mark() returns opaque as '
begin
NEW."" := 1;
return NEW;
end;
' LANGUAGE 'plpgsql';
CREATE
CREATE TRIGGER marks_round_marks BEFORE INSERT OR UPDATE ON "rr"
FOR EACH ROW EXECUTE PROCEDURE round_mark();
CREATE
UPDATE "rr" SET "òò"=1 WHERE "òò" = 1;
NOTICE:
14 matches
Mail list logo
