Hello Taral,
venerdì, 4 dicembre 98, you wrote:
>>hygea=> explain select * from comuni where nome = 'A%';
>>NOTICE: QUERY PLAN:
>>Index Scan using nome_comune_idx on comuni (cost=2.05 size=2 width=84)
>>^
T> The question was about LIKE, not =. Because LIKE uses regexp-style matching and
T
> On Fri, 4 Dec 1998, Ibrahim wrote:
>
> >
> > I've BSDi 3.1 & BSDi 4.0 . I always get same error messages when I
> > compiling postgresql 6.4.
> > The error messages :
> >
> > /usr/bin/yacc -d gram.y
> > /usr/sbin/yacc: f - maximum table size exceeded
> >
>
> I've BSDi 3.1 & BSDi 4.0 . I always get same error messages when I
> compiling postgresql 6.4.
> The error messages :
>
> /usr/bin/yacc -d gram.y
> /usr/sbin/yacc: f - maximum table size exceeded
> ^^^
>
> I'm using flex 2.5.4a.
That is strange
> On Thu, 3 Dec 1998, Nicholas Humfrey wrote:
>
> >
> > On Wed, 2 Dec 1998, Dustin Sallings wrote:
> > >it sounds like you're looking at the wrong tool for a particular job.
> >
> > I am trying to get the best of both worlds. A good relational database
> > system as well as being able to do tex
> >hygea=> explain select * from comuni where nome = 'A%';
> >NOTICE: QUERY PLAN:
> >Index Scan using nome_comune_idx on comuni (cost=2.05 size=2 width=84)
> >^
>
> The question was about LIKE, not =. Because LIKE uses regexp-style matching and
> we have no substring index functionality, it
On Fri, 4 Dec 1998, Taral wrote:
> >hygea=> explain select * from comuni where nome = 'A%';
> >NOTICE: QUERY PLAN:
> >Index Scan using nome_comune_idx on comuni (cost=2.05 size=2 width=84)
> >^
>
> The question was about LIKE, not =. Because LIKE uses regexp-style matching and
> we have no
> Paul Mookhachov <[EMAIL PROTECTED]> writes:
>
> > Hi!
>
> Hi !
>
> > How can I obtain information about tables' structure and list of
> tables
> > using psql.lib or Pg.pm (perl package)?
>
> I think you got no wayt to do it directly, but with here's a
> trick :
> all you ha
Hi, i have this query:
select * from libro where id_libro_key in (select id_libro from
libro_autore where id_auto
re in (select id_autore from autore where ((cognome = 'King' and nome =
'Stephen') OR (cog
nome = 'Clancy' and nome = 'Tom'\g
that return me this error:
ERROR: There is no operato
Hi again,
I have this query :
select prestito.*, libro.tipo,libro.id_libro from prestito,libro where
prestito.id_libro =
libro.id_libro_key
that return me (correct!):
id_libro|id_utente|data_prestito|visto|notifica1|notifica2|notifica3|tipo|id_libro
+-+-+-+
Hi again,
I have this 3 tables:
esame=> select * from prestito\g
id_libro|id_utente|data_prestito|visto|notifica1|notifica2|notifica3
+-+-+-+-+-+-
11| 37| 12-04-1998|f| | |
(1 row)
esame=> select *
The easiest way is to give it another name
select presto.*, libro.tipo, libro.id_libro as id_libro2 from ...
and just grab id_libro2 for the second id_libro.
You can also select it by column number in most interfaces.
-DEJ
> -Original Message-
> From: ZioBudda [SMTP:[EMAIL PROTEC
I really have no idea what you are truly asking for here, but here's a
crack at what I think you want.
select count(p.*) from prestito p, libro l
where p.id_libro = l.id_libro
group by p.id_utente, l.tipo
Try it...
-DEJ
> -Original Message-
> Hi again,
> I have this 3 tables:
I don't know why you are experiencing a problem here but I think I can
speed up that query. Let's try a rewrite.
SELECT * FROM libro l WHERE EXISTS(
SELECT la.id_libro FROM libro_autore la, autore a
WHERE la.id_libro = l.id_libro_key AND
la.id_autore = a.id_autore AND
I've recently compiled and put into service Posgresql v6.4. All is working
well.
I am looking for information on locating, compiling, and implementing a
Perl DBD or DBI for Postgresql. Can anyone assist?
Bob
On Fri, 4 Dec 1998, Jackson, DeJuan wrote:
> I don't know why you are experiencing a problem here but I think I can
> speed up that query. Let's try a rewrite.
tnx for the "new" query.
I have post my question1 here because I think that is a postgres problem.
ahhh...pgsql-sql ?
I've used PostgreSQL before, but has just joined this mailing list
again after having searched www.postgresql.org for any information
about 6.4. There's no mention of what is news in 6.4 anywhere to be
found. Why not? What _is_ new?
On Fri, 4 Dec 1998, Jackson, DeJuan wrote:
> I really have no idea what you are truly asking for here, but here's a
> crack at what I think you want.
> select count(p.*) from prestito p, libro l
> where p.id_libro = l.id_libro
> group by p.id_utente, l.tipo
> Try it...
parser: parse error a
On Fri, 4 Dec 1998, Bob Kruger wrote:
Just as with any other perl module:
/usr/local/bin/perl -MCPAN -e shell
install DBI
install DBD::Pg
#
# I've recently compiled and put into service Posgresql v6.4. All is working
# well.
#
# I am looking for information on locating, compiling, and imple
> I've used PostgreSQL before, but has just joined this mailing list
> again after having searched www.postgresql.org for any information
> about 6.4. There's no mention of what is news in 6.4 anywhere to be
> found. Why not? What _is_ new?
See the TODO list on the support page, or see the HISTOR
> -Original Message-
> From: ZioBudda [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, December 04, 1998 4:44 PM
> To: Jackson, DeJuan
> Cc: [EMAIL PROTECTED]
> Subject: RE: [GENERAL] question 3
>
> On Fri, 4 Dec 1998, Jackson, DeJuan wrote:
>
> > I really have no idea what you are tr
The Hermit Hacker wrote:
>
> On Fri, 4 Dec 1998, Ibrahim wrote:
>
> >
> > I've BSDi 3.1 & BSDi 4.0 . I always get same error messages when I
> > compiling postgresql 6.4.
> > The error messages :
> >
> > /usr/bin/yacc -d gram.y
> > /usr/sbin/yacc: f - maximum table size exceeded
> >
21 matches
Mail list logo
