reporting: 2011/08/01; value: 4
That are the series I want to get from the db.
--Alex
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
ts grow further, will be an RDBMS the right model
for time series storage? Any ideas on what else I could use?
Thank you very much!
--Alex
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
Hi, All!
When I execute this:
UPDATE HTMLPAGE SET PAGE_URL = REPLACE(PAGE_URL, '.dot', '.html')
WHERE PAGE_URL LIKE '%.dot';
I get the following error from psql. Could you tell me what is wrong
or how to fix it?
Thanks,
Alex
Failed to execute SQL : SQ
Hi,
I am Nevin Alex and I am using postgresql database for a year . But I
have’nt used table partitions: Please help me to do it in a better way. I got
it from the documentation that it is an inheritance capability and the Trigger
working but for dynamic data how can I implement that
On Tue, May 18, 2010 at 15:29, David Harel wrote:
> Greetings,
>
> I am trying to write a user function on the server to retrive image files.
> Currently I wrote the following:
> CREATE OR REPLACE FUNCTION perl_getfile(text)
> RETURNS OID AS
I think you meant returns bytea or text or something.
I do not know. It's sounds like the Oracle PL/SQL behavior is what I
want. Does PostgreSQL's pl/pgsql have such a feature? It's not in
the documentation anywhere. I'll check it from the office tomorrow.
Alex
On Feb 28, 2008, at 11:43 PM, Tom Lane wrote:
Ale
ot; or whatever
psql shows. Is that possible to obtain in plpgsql?
I've done extensive plpgsql programming before, but this is the first
time I need it to validate the external data in question.
Alex
---(end of broadcast)---
TIP 1: if pos
table control that are not listed in
datapack.
Thanks,
Alex
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
Is there a way to execute an external i.e. system command from inside a
pl/pgsql function?
Alex
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column&#
Are there performance advantages that can be achieved by wrapping a
complex SELECT into a stored procedure?
Alex
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
:
if the problem is caused by the the acquire lock->modify column->release
lock on the table 1, then why does it increase significantly increase as the
number of entries in the table 3 grows? The simulation maintains pretty much
constant rate of new requests coming to table 3.
Alex
-
ly reference to appropriate table (1) row and counter
value make it better?
Thanks,
Alex
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
RDBMS IMHO.
Alex Turner
NetEconomist
On Wed, 26 Jan 2005 12:11:49 +0200, Andrei Bintintan <[EMAIL PROTECTED]> wrote:
> The problems still stays open.
>
> The thing is that I have about 20 - 30 clients that are using that SQL query
> where the offset and limit are involved. So,
often very heavy, and the reason why one would want
to use a cursor.
Alex Turner
NetEconomist
On Thu, 20 Jan 2005 15:20:59 +, Richard Huxton wrote:
> Andrei Bintintan wrote:
> >> If you're using this to provide "pages" of results, could you use a
> >> curs
On Sun, 12 Dec 2004 19:18:00 -0700, Michael Fuhr <[EMAIL PROTECTED]> wrote:
> On Thu, Dec 09, 2004 at 03:19:56PM -0500, Alex Beamish wrote:
>
> > I'm getting a frustrating error
> >
> > ERROR: parser: parse error at or near "(" at character 201
&g
'console_flag' field was recently added and is close-ish to the
point that I think the parser is failing. And speaking of that, how I
am to interpret 'character 201' -- should I collapse the SQL into it's
minimal state (least number spaces) and go from that?
Thanks.
Alex
ps Trie
On Mon, 8 Oct 2001, Aasmund Midttun Godal wrote:
> 1. Is there a plperlu? ... unsafe version of perl?
In 7.2, there will be. In 7.1, you have to apply patches manually.
> 2. Is it possible to select which packages the plperl should have access to?
In 7.2, plperlu can do anything. plperl in eithe
he same time.
Didn't someone suggest dropping saving of parsed plans with OIDs
altogether, and saving the underlying query instead? The point was that
parser and planner are fast enough to make it unnecessary to save plans.
I don't remember what was disposition of that idea
-al
On Sun, 23 Sep 2001, Stephan Szabo wrote:
> On Sun, 23 Sep 2001, Alex Pilosov wrote:
>
> > It may be just me, or I am grossly misunderstanding syntax of outer joins,
> > but I see that plans for my queries are different depending on how I place
> > join conditions and so
JOIN" syntax to join all other tables as well,
otherwise, my query plans are _extremely_ slow.
any hints? Or I am grossly misunderstanding outer join symantics?
-alex
---(end of broadcast)---
TIP 2: you can get off all lists at once
On Mon, 10 Sep 2001, Stephan Szabo wrote:
>
> On Mon, 10 Sep 2001, Alex Pilosov wrote:
>
> > On Mon, 10 Sep 2001, Stephan Szabo wrote:
> >
> > > On Mon, 10 Sep 2001, Jeff Barrett wrote:
> > >
> > > > How can I call a shell script from within
On Mon, 10 Sep 2001, Stephan Szabo wrote:
> On Mon, 10 Sep 2001, Jeff Barrett wrote:
>
> > How can I call a shell script from within a pl/pgsql function that is called
> > as from a trigger. I do not want to interact with the script I just want it
> > to run. I do want the trigger to wait for th
time to do merge and
cleanup
Also included in the patch is ability to do 'select * from cursor foo'.
-alex
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
he result I want. I'm completely stumped - can anyone help?
Thanks in advance,
Alex
--
Alex Page, IT Department, Solid State Logic
E-Mail: [EMAIL PROTECTED]
Phone: +44 (0) 1865 842 300
Web: http://www.solid-state-logic.com
***
Its done and committed to CVS, will be in 7.2 release.
Also done is DBD::PgSPI, interface to access postgres from within your
stored procedure. (www.formenos.org/PgSPI)
-alex
On Wed, 11 Jul 2001, Jeff Eckermann wrote:
> I haven't seen anything on this list to say that pl/perlu is bein
resql.org/~petere/plsh.html
Well, as long as we all keep plugging our favorite languages, in 7.2, you
can use pl/perlu ;)
-alex
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail comma
Currently, this is not possible.
It will be possible in 7.2, or with a patch I'm working on...
On Mon, 9 Jul 2001, Alvar Freude wrote:
> Hi,
>
> I want to create a function (PL/pgSQL), which return multiple rows. But it
> fails -- when Creating the function, I get a notice:
>
> NOTICE: Pro
we do this? Please help.
>
> Thank you very much,
>
> Markus
>
> ---(end of broadcast)---
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to [EMAIL P
On Wed, 21 Feb 2001, Jeff MacDonald wrote:
> 1: can you call other stored procedures from within pl/Perl
No.
> 2: from within a pl/Perl script , can i do a select etc..
>i'm assuming no, because you cannot use DBI.. but just wondering
>if there is a way..
Not currently.
> 3: installing
Get an SQL book.
select * from basket
where date=(select max(date) where fruit='Apples)
and fruit='Apples';
On Thu, 15 Feb 2001, Steve Meynell wrote:
> Ok what I am trying to do is select out of the database the latest
> record meeting a certain criteria.
>
> Example:
>
> Number
Um, no.
You should run vacuum analyze AFTER you loaded up the data, otherwise,
your table statistics will be all wrong (it'll contain 'empty table'
statistics).
-alex
On Thu, 8 Feb 2001, Brice Ruth wrote:
> Stephan,
>
> Here is what EXPLAIN shows:
>
> NOTICE:
I receive strange error: the rows that begin with ascii symbols are ordered while all
other - are not!
Why is this happen?
Regards,
Alex
'klasse' )
is executed successfully.
Is it possible to use INTERSECT and UNION keywords in subqueries?
Regards,
Alex
then 3, and so forth.
My question is, is it possible to alter the sequence last_value column, as
I need the serial number to begin from 1000?
Thanks,
Alex
WHERE OID=oid-value, followed by pg_fetch_row().
Thanks John, and the other person that replied to my email (I know it is a
bit of a stupid question, but in such an unpopulated list, I don't think
there's any reason to post privately).
This leads to another question. If someone adds another row during this,
what will happen?
Thanks,
Alex
data back again? I am thinking there must be a faster,
more efficient way.
Thanks,
Alex
36 matches
Mail list logo
