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 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
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
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
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
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
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
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
Hi Merlin
On Thu, Oct 10, 2013 at 1:00 AM, Kaare Rasmussen ka...@jasonic.dk 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
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
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
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.
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,--Tlf:3816 2582
Kaki Data
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.00Email: [EMAIL
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:3816 2582
Kaki Datatshirts, merchandize Fax:3816
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:3816
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:3816 2582
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
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?
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
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
I miss subject. 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
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
How can I see a view in psql after having created it? If I enter
\d viewname 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'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?
26 matches
Mail list logo