Hi all,
I have the following query:
SELECT count(1)
FROM providers p JOIN class_default cdUSING (id_provider)
JOIN user_data udUSING (id_class)
JOIN v_user_traffic ut USING (id_user)
WHERE id_user_status in (4,5) AND
p.company = 'X';
is n
Laurette Cisneros writes:
> On Suse 8.0, I'm trying to compile postgresql 7.3.1.
>
> configure gives the following error:
> checking for inflate in -lz... yes
> checking for CRYPTO_new_ex_data in -lcrypto... no
> configure: error: library 'crypto' is required for OpenSSL
>
> Yast2 doesn't show me
On Sun, Jan 12, 2003 at 17:31:34 +0100,
Gaetano Mendola <[EMAIL PROTECTED]> wrote:
> Hi all,
>
> I have the following query:
>
> SELECT count(1)
> FROM providers p JOIN class_default cdUSING (id_provider)
> JOIN user_data udUSING (id_class)
> JOIN v
"Bruno Wolff III" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Gaetano Mendola <[EMAIL PROTECTED]> wrote:
> > Hi all,
> >
> > I have the following query:
> >
> > SELECT count(1)
> > FROM providers p JOIN class_default cdUSING (id_provider)
> >
On Sun, 12 Jan 2003, Gaetano Mendola wrote:
> "Bruno Wolff III" <[EMAIL PROTECTED]> wrote in message
> [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> > Gaetano Mendola <[EMAIL PROTECTED]> wrote:
> > > Hi all,
> > >
> > > I have the following query:
> > >
> > > SELECT count(1)
> > > FROM provider
On Sun, Jan 12, 2003 at 18:07:14 +0100,
Gaetano Mendola <[EMAIL PROTECTED]> wrote:
> "Bruno Wolff III" <[EMAIL PROTECTED]> wrote in message
>
> > Using "JOIN" fixes the order that tables are joined in. If you are
> > just doing inner joins, then you probably don't want to use the "JOIN"
> > keyw
Hi,
Does Postgres allow multibyte characters (e.g. japanese kanji) in table names, column
names etc ? If yes, do I have to do any special setting? Japanese characters as data
has been no problem at all. I have setup both the server (database) and client (psql)
as EUC_JP encoding. I am using Pos
Hi All,
May I know how can I replace 'Enter Character' to 'balnk space' character,
while retreiving data from my database.
Sreedhar
"Faith, faith, faith in ourselves, faith, faith in God, this is the secret
of greatness.
If you have faith in all the three hundred and thirty millions of your
mytho
