I have several questions reagaring the kind of increase in speed I can
expect when I use a multi-column index. Here's what I've done so far.
I've written some search functions which operate on character varying
data used to represent molecular structures. We call this a Smiles string.
I want to op
Mihail Nasedkin wrote:
Hello, Michael.
Thank you for answer January, 20 2005, 21:48:30:
MF> On Thu, Jan 20, 2005 at 03:45:58PM +0500, Mihail Nasedkin wrote:
How (where) I can get all OID's of the PostgeSQL
installation?
In other words where OID's is stored? Is it stored in special table?
MF> See
On Fri, Jan 21, 2005 at 11:17:34AM +0500, Mihail Nasedkin wrote:
> I have already read about "System Columns" of the PostgreSQL documentation.
> In the table "pg_catalog.pg_attribute" column "attrelid" contain
> only "system OID's" but not OID's from records of the user tables.
>
> But I would li
Finally I think that did the trick.
I did see the GUI editor for security and set SELinux to off and re-booted.
I ran the rpm text you gave me
I can use pgadmin with no errors, now for another 12 hours of transferring
data :( so I can work on the views and stored procedures.
This list is a great r
"Joel Fradkin" <[EMAIL PROTECTED]> writes:
> Is there an action I can take now since it is installed and in theory the
> RPM's are up2date. Sorry I have a few books on postgres Oreily and Sams, but
> it seems a bit deep on install.
Sure, you can use the RPMs you have. You want something like (as
Tom thank you for the reply.
I believe I turned all that off during the install (no firewall).
But I can try again.
Is there an action I can take now since it is installed and in theory the
RPM's are up2date. Sorry I have a few books on postgres Oreily and Sams, but
it seems a bit deep on install.
I just tried hard to return
a single record fromout a plpgsql-function. While the (otherwise excelent)
documentation didn't give me an answer, I found out that this works:
select into ret false, balance, balance;
return ret;
while ret is a composite type.
This construction howeve
Now I read all the posts and I have some answers.
Yes, I have a web aplication.
I HAVE to know exactly how many pages I have and I have to allow the user to
jump to a specific page(this is where I used limit and offset). We have this
feature and I cannot take it out.
> SELECT * FROM tab WHERE c
