Unless you've good reasons to do so it's best to store the file on the
file system and the file name/path in the database ...
On 05/18/2011 22:20, Emi Lu wrote:
Hello,
To save pdf files into postgresql8.3, what is the best column type?
bytea, blob, etc?
Thank you,
Emi
<>
--
Sent via pgsq
On 05/18/2011 23:00, Karsten Hilbert wrote:
On Wed, May 18, 2011 at 10:46:23PM +0200, Julien Cigar wrote:
Unless you've good reasons to do so it's best to store the file on
the file system
Why ?
If you suggest reasons are needed for storing the PDF in the
database I'd l
On 05/18/2011 23:27, Karsten Hilbert wrote:
On Wed, May 18, 2011 at 11:21:43PM +0200, Julien Cigar wrote:
Unless you've good reasons to do so it's best to store the file on
the file system
Why ?
If you suggest reasons are needed for storing the PDF in the
database I'd l
Hello,
I have a classic parent -> child relation (id, container_id) and I would
like to find the full hierarchy for a child, something like
A
/ \
B C
|
D
given D I want {A,B,C}
WITH RECURSIVE hierarchy(level, container_id, titles, containers) AS
(SELECT 1 AS level, container_id, ARRAY[
mmh I made a little mistake: it was {A,B} of course, not {A,B,C}
On 08/23/2011 12:03, Julien Cigar wrote:
given D I want {A,B,C}
--
No trees were killed in the creation of this message.
However, many electrons were terribly inconvenienced.
<>
--
Sent via pgsql-sql mailing list (pgs
create table foo as select * from bar;
just add "where 1=2" if you just want the schema
On 08/25/2011 11:44, pp...@sapo.pt wrote:
Hello to all,
Can anybody tell me the sql instruction to create a new table with a
select of other table?
I need to create a new table based on paralell of a ta
use a regex ?
On 08/30/2011 16:51, Emi Lu wrote:
Good morning,
Does psql provide something like the following query command?
select * from tablename
where col1 not ilike ('str1%', 'str2%'... 'strN%')
Thanks a lot!
Emi
--
No trees were killed in the creation of this message.
However, many
Try to raise work_mem
On 12/07/2011 15:34, Raj Mathur (राज माथुर) wrote:
Hi,
I'm trying to correlate Call Data Records (CDRs) from two Asterisk
servers, one of which uses the other for telephony. The data is in
the tables cdr and cdr2. With some indexes, the query and explain
result are:
exp
On 12/07/2011 16:14, Raj Mathur (राज माथुर) wrote:
On Wednesday 07 Dec 2011, Julien Cigar wrote:
Try to raise work_mem
Odd, I tried adding work_mem=50MB / 256MB / 1024MB into postgres.conf
and the times actually went up to over 12 seconds. Leaving it commented
results in the 4-second time
Hello,
I have an extremely bad plan for one of my colleague's query. Basically
PostgreSQL chooses to seq scan instead of index scan. This is on:
antabif=# select version();
version
2012-04-05 1:38 PM, Julien Cigar wrote:
Hello,
I have an extremely bad plan for one of my colleague's query.
Basically PostgreSQL chooses to seq scan instead of index scan. This
is on:
antabif=# select version();
ve
) GROUP BY geo_id
) as t_geo
JOIN hit.geo_candidates gc
ON gc.id = t_geo.geo_id;
On 2012-04-05 2:08 PM, Julien Cigar wrote:
SELECT
t_geo.frequence, ST_SetSRID(gc.geom, 4326) as geom
FROM (
SELECT
geo_id , count(*) AS frequence
FROM
hit.context_to_context_links
WHERE
FYI, raising cpu_tuple_cost from 0.01 to 0.5 fixed the problem..!
On 04/05/2012 14:43, Julien Cigar wrote:
Hi Mario,
Setting it to > -1, or even removing the condition doesn't change
anything .. the problem is more that the estimate of the join point
sucks pretty much ..
Julien
On 02/18/2013 15:39, Bert wrote:
Hello,
Thanks the nice people on irc my problem is fixed.
I changed the following settings in the postgres.conf file:
default_statistics_target = 5000 -> and I analyzed the tables after
the change of course -> now I only got 2 plans anymore, in stead of 3
defa
On 02/18/2013 16:20, Julien Cigar wrote:
On 02/18/2013 15:39, Bert wrote:
Hello,
Thanks the nice people on irc my problem is fixed.
I changed the following settings in the postgres.conf file:
default_statistics_target = 5000 -> and I analyzed the tables after
the change of course ->
Hello,
I have a problem with the ALL() subquery expression.
I have three tables:
- specimens
- test_bits
- specimen_test_bits
The specimen_test_bits table contains two foreign keys, one to
specimens(id), another to test_bits(id).
Here is an output of specimen_test_bits:
muridae=> select * from
On Wed, 2007-11-14 at 11:56 +, Richard Huxton wrote:
> Julien Cigar wrote:
> >
> > What I would like is a query that returns all the specimen_id of
> > this table which have _all_ the given test_bit_id.
> [snip]
> > With the following I got a syntax error:
&g
I finally found a solution:
SELECT specimen_id
FROM specimen_test_bits
GROUP BY specimen_id
HAVING array_accum(test_bit_id) = '{2,3,4}';
.. but I don't think it's very "clean" ..
what do you think ?
Thanks
On Wed, 2007-11-14 at 15:50 +0100, Julien Cigar wro
Thanks :) it works as expected
Julien
On Wed, 2007-11-14 at 14:31 +0100, hubert depesz lubaczewski wrote:
> On Wed, Nov 14, 2007 at 02:39:02PM +0100, Julien Cigar wrote:
> > With the following I got a syntax error:
> > select specimen_id
> > from specimen_test_bits
> &
'(-8,25)' <@ polygon
'((-3,10),(8,18),(-3,30),(-10,20))';
ERROR: operator does not exist: point <@ polygon
HINT: No operator matches the given name and argument type(s). You may
need to add explicit type casts.
... but without success as you can see ;\
In advance thanks
uot;
thanks
On Wed, 2008-05-07 at 15:38 +0100, Richard Huxton wrote:
> Julien Cigar wrote:
> > Hello,
> >
> > I'm busy to work on an application where the user can select (with
> > precision) an area on a map (for example the contours of a lake) and I
> > h
> 3
>
> select concat_something(my_field) from my_table group by something;
> the result expected would be someting like that : 1/2/3 (with a
> separator it would be really nice)
>
> I hope that I am not asking for too much ;)
>
> Thanks to all
>
--
Julien Cigar
Belg
Also, the array_accum aggregate isn't present by default, you need to
create it with :
CREATE AGGREGATE array_accum (anyelement)
(
sfunc = array_append,
stype = anyarray,
initcond = '{}'
);
On Fri, 2008-08-22 at 18:24 +0200, Julien Cigar wrote:
> of course: http://r
of course: http://rafb.net/p/EOaYfO59.html
Julien
On Fri, 2008-08-22 at 15:58 +0200, Nacef LABIDI wrote:
> any explanations ?
>
> On Fri, Aug 22, 2008 at 6:07 PM, Julien Cigar <[EMAIL PROTECTED]>
> wrote:
> array_accum ?
>
>
> On
24 matches
Mail list logo
