On Mon, 11 Sep 2000, Lamar Owen wrote:
> Max Pyziur wrote:
> > I dropped my databases, uninstalled the 7.0.2-2 rpms and installed 6.5.3 rpms on
> > my development RH6.2 Linux 2.2.14-5.0 system and I still get the anomalous query
> > result on that box.
>
> This is a RedHat 6.2 locale problem.
Thanks Darrin and Stuart.
-Tony
Darrin Ladd wrote:
> Here's what you are looking for:
>
> SELECT pg_class.relname
> FROM pg_class, pg_attribute
> WHERE pg_attribute.attname = 'area'
> AND pg_attribute.attrelid = pg_class.oid;
>
> This should give you all of the classes (tables) which have th
Here's what you are looking for:
SELECT pg_class.relname
FROM pg_class, pg_attribute
WHERE pg_attribute.attname = 'area'
AND pg_attribute.attrelid = pg_class.oid;
This should give you all of the classes (tables) which have the attribute
(field) 'area'.
Cheers,
Darrin
-Original Message-
You should be able to query the system table that holds that column names.
Not sure which it is tho.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf
Of G. Anthony Reina
Sent: Monday, September 11, 2000 4:38 PM
To: [EMAIL PROTECTED]
Subject: [SQL] How can I s
I have a database with several tables. I'd like to pull out a list of
names for the tables that contain the field (class) name 'area'.
Can this be done?
-Tony
Normally it's done with self-relation. You need a table with
"ID" and "PARENT_ID". PARENT_ID will contain null for
root level and other row's ID for children. One warning: going through
such tree could be slow. I don't know is there anything PostgreSQL
specific that might help. I know that Oracle
Roberto Mello <[EMAIL PROTECTED]> writes:
> I am porting some VERY big functions to PG for a data warehousing system
> (that is GPL'd BTW) and it seems that the results of one portion of the
> function (e.g. a create table or a series of inserts) are invisible to
> the other parts which obviously
Palle,
thanks for the message. I've created bulgarian locale
from similar russian sources (I believe it's CP1251 charset).
Hope it would be ok.
Regards,
Oleg
On Mon, 11 Sep 2000, Palle Girgensohn wrote:
> Date: Mon, 11 Sep 2000 15:51:23 +0200
> From: Palle Girgensohn <[
Title: Tree structure
Anybody know how to make a tree structure using related tables using Postgres. Something like a directory structure is what I'm aiming for. I'm sure there is an easy way but I'm having probs.
Any help would be appreciated.
Ben.
Oleg Bartunov wrote:
>
> Hi,
>
> I'm going to Bulgaria this week to setup FreeBSD server running
> postgres and would like to know if somebody has an experience
> with postgres and bulgarian locale. Actually, I need
> bg_BG locale for FreeBSD. interesting that searching for
> subject in internet
I've got a table containing some timesheet data.
Fields are emp, earncode, lo_shift, hi_shift.
SELECT emp, sum(hi_shift - lo_shift) as reghrs from timesheet
where earncode in ('R', 'C', 'X') order by emp
will give me all the regular hours
SELECT emp, sum(hi_shift - lo_shift) as ovrhrs from tim
Hi,
I'm going to Bulgaria this week to setup FreeBSD server running
postgres and would like to know if somebody has an experience
with postgres and bulgarian locale. Actually, I need
bg_BG locale for FreeBSD. interesting that searching for
subject in internet doesn't provide any information.
The
12 matches
Mail list logo
