I've been asked if there is a way to LIMIT the number of results displayed
when doing a SELECT with postgresql, by a former user of mysql. Wasn't
sure if there is an easy way to do this or not. I've don't it before, but
in a very round about way... any suggestions.
> with mySQL and SELECT querie
Kevin Heflin wrote:
>
> I've been asked if there is a way to LIMIT the number of results displayed
> when doing a SELECT with postgresql, by a former user of mysql. Wasn't
> sure if there is an easy way to do this or not. I've don't it before, but
> in a very round about way... any suggestions.
Select * From table_name limit 1;
-Original Message-
From: Kevin Heflin [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, March 30, 1999 10:00 PM
To: PGSQL-General (E-mail)
Subject:[GENERAL] limit select question
I've been asked if t
On Wed, 31 Mar 1999, Michael Davis wrote:
> Select * From table_name limit 1;
I'm running postgres6.4.2, and this query fails with:
ERROR: parser: parse error at or near "1"
I was told I could gain this feature by adding the 6.4.2 feature patch.
But when I tried installing the patch, anything
Good point. I am running 6.5. So it has been fixed. I am not sure what
patch is needed to make this work on 6.4.2.
-Original Message-
From: Kevin Heflin [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, March 31, 1999 12:26 AM
To: Michael Davis
C
On Wed, 31 Mar 1999, Michael Davis wrote:
> Good point. I am running 6.5. So it has been fixed. I am not sure what
> patch is needed to make this work on 6.4.2.
Is version 6.5 to be had some where, or is it only in beta?
I sure could use that feature on a project I'm working on right now...
It entered into beta test this week. There are several features that I
really need so am jumping in early. You have to know how/where to get the
source code because it will not even be available for download until next
week.
-Original Message-
From: Kevin Heflin [SMTP:
> 1) All Celerons ship with a 128K on chip cache. Which means the cache runs
> at the same clock rate as the chip.
> 2) The PIIs ship with 512K cache, however it's level 2 so it only runs at bus
> speed.
No, it runs at half the core speed.
Maarten
ps. do you also find it annoying when ppl quote
Hi,
Does PostgreSQL 6.4.2 have a build in Unix crypt() function? Or has
someone implemented it that you'd like to share?
L L Richi Plana 8^) ,-,-. ,-,-. ,-,-. ,-,-. ,-
LL LL Systems Administrator / / \ \ / / \ \ / / \ \ / / \ \ / /
L Mosaic Communications,
It's depends upon your needs, but if you're on a Unix system why not just
access the system crypt function. You could create a PostgreSQL C function
to easily access it. Just look in contrib for an example of the code.
If you're on a Windows system I'd say give up now unless you want to
implemen
May be I'm missing something, but why not use the cursor?
Do the select once and then fetch as many rows as you need.
Rudy
On 31 Mar 99, at 1:20, Michael Davis wrote:
> Select * From table_name limit 1;
>
> -Original Message-
> From:Kevin Heflin [SMTP:[EMAIL PROTECTED]]
> Se
> > 1) All Celerons ship with a 128K on chip cache. Which means the cache
> > runs at the same clock rate as the chip. 2) The PIIs ship with 512K
> > cache, however it's level 2 so it only runs at bus speed.
>
> No, it runs at half the core speed.
Oh shoot. You are absolutely right. I'm terribly
On Wed, 31 Mar 1999, Rudy Gireyev wrote:
> :-) That's funny. Although I think ppl do this for the archives. That way when
> someone is searching for an answer and reads an email they don't need to go
> scouring for the entire thread and can get all the info in that one email. Just a
> thought. An
13 matches
Mail list logo
