-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
> `SELECT * FROM Entities*;'
>
> up to and including 7.0.x.
>
> In 7.1, I believe a select on the parent will automatically show the
> children and you will need to do something like `SELECT * FROM ONLY Entities'
> to exclude descendant tables.
Yes
Ian Turner wrote:
>Is there a way to set it up so that tables B and C are both children of
>table A, but where if you add records to B or C, they will show up in A as
>well (albiet without the extra fields provided by B and C)?
>
>In case that wasn't thouroughly confusing, allow me to tr
On Sat, 29 Jul 2000, dave wrote:
> Hi,
>
> Not sure which list this should go to, so I've posted to both.
>
> I installed pgsql 7.02, from the RH RPMS, and got pgsql working OK. I
> then went back to my php-4.0.1pl2 distribution which I'd had working
> for a while to try and compile in pgsql.
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
> Is there a way I can select the top 50 rows from table, 51 - 100 rows from
> table etc (with order clause)? It is because I am writing a message board
> and I would like to create the prev/next button on different page.
Look at the documentat
On Sat, 29 Jul 2000, [EMAIL PROTECTED] wrote:
> Dear all,
>
> Is there a way I can select the top 50 rows from table, 51 - 100 rows from
> table etc (with order clause)? It is because I am writing a message board
> and I would like to create the prev/next button on different page.
>
> Many
dave wrote:
> Does anyone know what I should be doing? I'd like to try and keep this
> as much RPM based as possible (i.e. I did think of downloading ALL
> sources and compiling the lot, but I'd like to avoid that - I mean my
> pgsql install works fine)
In the RPM distribution of PostgreSQL, you
* [EMAIL PROTECTED] <[EMAIL PROTECTED]> [000729 10:57] wrote:
> Dear all,
>
> Is there a way I can select the top 50 rows from table, 51 - 100 rows from
> table etc (with order clause)? It is because I am writing a message board
> and I would like to create the prev/next button on different
Dear all,
Is there a way I can select the top 50 rows from table, 51 - 100 rows from
table etc (with order clause)? It is because I am writing a message board
and I would like to create the prev/next button on different page.
Many thanks.
Best regards,
Boris
On Fri, 28 Jul 2000, Tom Lane wrote:
> * convert the value to Unix timestamp notation (subtract off enough
> days to make 0 correspond to 1/1/1970, then multiply by 24*60*60).
> * coerce the resulting integer to abstime and then to whatever
> datatype you want to use (timestamp or dat
Hi,
Not sure which list this should go to, so I've posted to both.
I installed pgsql 7.02, from the RH RPMS, and got pgsql working OK. I
then went back to my php-4.0.1pl2 distribution which I'd had working
for a while to try and compile in pgsql.
tried --with-pgsql (also =/usr, =/usr/local, =/u
[EMAIL PROTECTED] wrote:
>
> Hi all,
>
> I have downloaded the dia 0.80 for Redhat. But it has only diagrams for
> flowchart, network, sybase uml and circuit. I would like to use it to show the
> table fields and the relationship. How can I do it?
I used classes and associations in UML. Worked
Hi all,
I have downloaded the dia 0.80 for Redhat. But it has only diagrams for
flowchart, network, sybase uml and circuit. I would like to use it to show the
table fields and the relationship. How can I do it?
Many thanks!!!
Best regards,
Boris
Quoting Karl DeBisschop <[EMAIL PROTECTED]>:
"Robert B. Easter" wrote:
>
> On Sat, 29 Jul 2000, [EMAIL PROTECTED] wrote:
> > Dear all,
> >
> > I need drawing tools to show the table relationship. I have used pgaccess but
> > it seems that the effect is not very good. Are there any recommendations?
>
> Dia
>
> http://www.lysator.liu.se/~al
Hi,
I see this line in the postgresql manual
The Reference Manual gives a more detailed explanation of these
catalogs and their attributes. However,
The major Postgres system catalogs shows the major entities and their
relationships in the system
catalogs.
but I can't find the reference manual
On Sat, 29 Jul 2000, [EMAIL PROTECTED] wrote:
> Dear all,
>
> I need drawing tools to show the table relationship. I have used pgaccess but
> it seems that the effect is not very good. Are there any recommendations?
Dia
http://www.lysator.liu.se/~alla/dia/
--
- Robe
Dear all,
I need drawing tools to show the table relationship. I have used pgaccess but
it seems that the effect is not very good. Are there any recommendations?
Best regards,
Boris
16 matches
Mail list logo
