On 2016-05-31 13:24, Stefan Keller wrote:
> We chose RUM just because there are GIN and VODKA :)
> But some people already suggested several meanings like Really
Useful iMdex :)
> We are open for suggestion.
So I propose: "Ranking UMdex" ;-)
How about "Russian Unbelievable Magic"? Or just
Hi
As json essentially only has three basic data types, string, int, and
boolean, I wonder how much of this - to index, search, and sort on
unstructured data - is possible. I guess part of the answer would be
'jsquery and vodka', but let me describe the problem first.
The basics is, that I
On 2015-12-03 01:04, Jim Nasby wrote:
We have a client that has a similar (though also a bit different)
need. Specifically, they get an XML document that has element
attributes that tell you what data type the element should contain. We
convert the XML to JSON (easy thanks to plpython), which p
On 2015-12-03 02:06, Merlin Moncure wrote:
I feel your pain. jsquery is superb for subdocument searching on
*specific* subdocuments but range searching is really limited. Value
searching is there for numerics but dates and text range searching are
not present. We also have to understand that
On 2015-12-03 05:04, Tom Lane wrote:
Yeah. The problem here is that a significant part of the argument for
the JSON/JSONB datatypes was that they adhere to standards (RFC 7159
in particular). I can't see us accepting a patch that changes them
into JSON-plus-some-PG-enhancements.
Would be nice
Hi Oleg
This is known problem, that's why we stop developing jsquery and are
working on sql-level query language for jsonb, then you'll use all
power and extendability of SQL. The idea is to use power of
subselects and unnest to unroll jsonb to sql level.
There is presentation at pgconf.eu <
Hi
I'm trying to determine the best way to represent a simple tree
structure (like a file/dir tree or a uri path). I guess that's done a
zillion times before; I just don't seem to be able to find the right
solution. I have one special request, that I'd like to find all
'shorter' paths, i.e. g
Hi Alban
4. Using a recursive common table expression (CTE).
http://www.postgresql.org/docs/9.2/static/queries-with.html
Yes, you're right. In fact that's what I'm testing a way to replace, as
I'm not confident in the performance in all situations. My fault
entirely; I should have told so f
Sorry, got tangled up in this thing called 'real life'.
If I understand you correctly, you want a prefix match, and sure there's
a PostgreSQL extension for that:
OK, that seems to do the job, thanks a lot. The only small quibble is
that it's an extension.
I'm quite surprised there seem to b
Hi Merlin
On Thu, Oct 10, 2013 at 1:00 AM, Kaare Rasmussen wrote:
I'm quite surprised there seem to be no way in core to treat an array as an
array. Using @> treats it as a set, AFAICT.
can you elaborate on that?
merlin
To me, an array is a vector (or a vector of vectors). So I&#
Hi Rémi
Hey sorry if my answer is stupid,
but there is an extension for array, even if it is limited to int (but
int could be indexes of row)
It's named http://www.postgresql.org/docs/9.3/static/intarray.html
It provides essential function, although lacking some (I
re-implemented union of arra
Hi
Trying to write a sql function to return hstore generated from a select.
But I'm thinking there must be a better way.
SELECT 'key => "' || s.part || '"')::hstore
is neither pretty nor secure. At least I need to escape any '"' in
s.part. I'll do so if there's no better way to write this (?
On 12/08/2013 11:45 AM, Magnus Hagander wrote:
If it's just for a single value, you can just use
SELECT hstore('key', s.part)
It also takes array (either one big array, or one array of keys and
one array of values).
Super! I knew I was missing the obvious.
--
Sent via pgsql-general mail
Hi
I tried to find the page with PostgreSQL consultants. After 10 minutes I gave
up.
I believe that I've heard that there is such a page, but maybe I'm wrong? Or
maybe I just suck at searching the PostgreSQL site ?
--
Kaare Rasmussen--Linux, spil,--Tlf:
Sorry if this is obvious to you, but it's not obvious to me.
In 7.4 this
psql -h 127.0.0.1 test and
psql -h localhost test
will be authenticated as ipv6 addresses. As long as you know, it's OK, but is
this intentional?
--
Kaare Rasmussen--Linux, spil,--Tlf:
believe this has been discussed before, but it does not seem to be a small
or an easy task to implement.
--
Kaare Rasmussen--Linux, spil,--Tlf:3816 2582
Kaki Datatshirts, merchandize Fax:3816 2501
Howitzvej 75 Åben 12.00-18.00
re, or what?
Just in case there is a company with enough interest in this matter.
Next question would of course be if anyone would care to do it even though
they're paid, but one hypothetical question at the time :-)
--
Kaare Rasmussen--Linux, spil,--Tlf:38
27;re right. There are some too big changes close to
being made - if I have read this list correctly. Table spaces and PITR would
certainly change it.
But if the freeze could start after 7.5 and last two-three years, it might
help things.
--
Kaare Rasmussen--Linux, spil,--
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?
How can I see a view in psql after having created it? If I enter
\d I can see the fields, but how can I see what makes up the
view? Best if the original CREATE statement could be listed somehow.
I got an error when accessing a view. The view looks like this:
CREATE TABLE ar_contacts(
contact_seq int,
update_date date,
period date,
paidfloat,
sales float,
last_date date,
due fl
I miss . I know the answer is that I can write them myself,
but I don't know where to start or end.
See this construct:
CREATE TABLE gl-amount (
glam_nr int,
period date,
entry_amount numeric(9,0),
PRIMARY KEY (glam_seq,period)
);
CREATE VIEW glam_curmth_v AS
SELECT entry
I can't figure this one out. I need a tree structure like this
Number Pointer
10
21
31
42
50
61
75
This should somehow show up like this
Number
1
2
4
3
6
5
7
The whole excercise is because I'd like to show a tr
As I tried to make a function for this percent calculation I fell over
the problem of passing a table to the function. I'd like to make this
function:
create function NumRows(table) returns int4
as 'select count(*) from $1'
language 'sql';
Is this possible?
> Can I somehow get the total number of rows in
> a function?
create function numRows() returns int4
as 'select count(*) from '
language 'sql';
> select var1, count(*) / numRows() * 100 from table1 group by var1;
maybe this is better
select var1, (count(*) * 100) / numRows() from tab
> P.S. In oracle, I'd use a sub-query:
>
> SELECT var, COUNT(*) / total_count
> FROM temp,
>( SELECT COUNT(*) AS total_count
>FROM temp
>)
> GROUP BY var;
I thought that subqueries were allowed in PostgreSQL after 6.2?
I've made a CGI script can insert, update and delete rows in a table. It
started as a project directed towards a specific table, but I soon
realized that it is possible to do a generic CGI script to handle any
table.
So I've done that. Now I want someone to test it. Notice however that it
is stil
Going through the documentation I can only find little about outer
joins. One statement is in the Changes doc about including syntax for
outer joins, but there doesn't seem to be implemented any code after
that.
Is it true that there's no outer joins yet? Any plans? Btw. what is the
syntax for ou
> The July issue of sys admin has a feature on Perl for DBAs.
> This is actually better coverage than you get in most perl
> Shall I fax you a copy?
Yes, please :-)
I'd like to ask if it's on the web?
I'm doing a db layout in Logic Works' Erwin. It can generate SQL
statements to create the database. Of course it doesn't include support
for PostgreSQL (yet) but I wondered which syntax was closest of the
supported ones.
These are supported:
DB2
SQL Server
Rdb
Oracle
SQLBase
Watcom/SQL Anywhere
I
Anybody that knows anything about Dome ( http://www.htc.honeywell.com/dome/
) ?
It seems to be a quite extensive CASE tool. Can I use it to build a
Database layout and let it generate sql statements to create the database??
> But I am not imagining the random "I have rolled back the current
transaction
> and am going to terminate your database system connection and exit."
messages.
I'm wondering if you ever reported these problems to this list or the
the hackers list? I've been reading both regularily and don't reca
32 matches
Mail list logo
