Actually, given that there may not always be a backup_employee field (can be
null) I think I'm forced to use an outer join to return all team leader
records regardless if a matching backup_employee record exists. I'll test
yours out and see.
Thank you!
-Original Message-
From: Michael
On Jan 31, 2004, at 7:03 AM, Anony Mous wrote:
Table #1
employee_id (pk)
employee_name
Table #2
teamleader_employee_id
backup_employee_id
both fields in table 2 need to do a lookup in table 1 to get the name
of the actual employee. Do I need to use nested queries to accomplish
this? Any help
It seems that something you added to the unknown handler triggers it to
be called again. Might be that spi_exec isn't defined at the time that
script is evaluated.
Jan
Craig Addleman wrote:
How do I use the pltcu unknown module to auto-load a return value from a
select query? I'm trying to bo
Hi there,
> > > >Uh, how about threads. I know that you don't need them much but
> > > >it sure would be nice to be able to do background processing.
> > >
> > > PHP doesn't support threads?
> >
> > Nope...
> >
> >I've always thought of Forking as
> > > overkill where threads are light a
> Randolf Richardson wrote:
> >>>In dealing with web applications and frontends to database or
> >>>even just a dynamic web site PHP has every bit the power and ability
that
> >>>Java does and the development time is way down.
> >>
> >>Uh, how about threads. I know that you don't need them much bu
On Thu, Jan 29, 2004 at 23:39:23 -1000,
Susemail <[EMAIL PROTECTED]> wrote:
> Is this good advice?
>
> IDENT Authentication failed for user "postgres"
>
> This error has everything to do with the way distros set up access rights for
> postgres. They are way too restrictive and leave you wonder
On Thu, Jan 29, 2004 at 23:04:53 -0300,
Alvaro Herrera <[EMAIL PROTECTED]> wrote:
> On Thu, Jan 29, 2004 at 08:50:47PM -0500, Manuel Tejada wrote:
>
> > By the way, what does mean RHEL3?
>
> "Red Hat Entreprise Linux", a commercial Linux distribution (meaning you
> shouldn't use it unless you p
On Fri, Jan 30, 2004 at 12:38:43PM +0100, NTPT wrote:
> > I have a large table (potentially tens or hundreds of millions of rows) and
> > I need to extract some number of these rows, defined by an integer primary
> > key.
> >
> > So, the obvious answer is
> >
> > select * from table where id i
On 30/01/2004 09:39 Susemail wrote:
[snip]
In any case I don't have a pg_hba.conf file:
You should have, unless you haven't done an initdb...
:~> locate pg_hba.conf
/usr/share/postgresql/pg_hba.conf.sample
:~>
Should I have one? If I should, where does it belong?
It's in PostgreSQL's data dir. O
- Puvodní zpráva -
Od: "Steve Atkins" <[EMAIL PROTECTED]>
Komu: <[EMAIL PROTECTED]>
Odesláno: 28. ledna 2004 20:32
Predmet: [GENERAL] Specifying many rows in a table
> I have a large table (potentially tens or hundreds of millions of rows) and
> I need to extract some number of these ro
Is this good advice?
IDENT Authentication failed for user "postgres"
This error has everything to do with the way distros set up access rights for
postgres. They are way too restrictive and leave you wondering what to do
next.
Do yourself a favour and change authentication type in pg_hba.conf
11 matches
Mail list logo
