On 27 Jun 2017, at 17:06, Merlin Moncure <mmonc...@gmail.com> wrote:
>
>> On Tue, Jun 27, 2017 at 10:01 AM, Colin 't Hart <colinth...@gmail.com> wrote:
>> Hi,
>>
>> The following rather contrived example illustrates that lag(), lead()
>> (and proba
Hi,
The following rather contrived example illustrates that lag(), lead()
(and probably other functions) can't automatically cast an integer to
a bigint:
select lag(sum,1,0) over () from (select sum(generate_series) over
(order by generate_series) from generate_series(1,10)) x;
ERROR: function
Hi,
I've been reading
wiki.postgresql.org/images/2/25/Full-text_search_in_PostgreSQL_in_milliseconds-extended-version.pdf
with interest and am wondering if these patches ever made it in to the
"official" version of Postgresql?
I've tried doing some of the queries as described in the slides using
David et al,
How about something like this?
Cheers,
Colin
diff --git a/doc/src/sgml/ref/select.sgml b/doc/src/sgml/ref/select.sgml
index e603b76..a68014b 100644
--- a/doc/src/sgml/ref/select.sgml
+++ b/doc/src/sgml/ref/select.sgml
@@ -33,13 +33,14 @@ PostgreSQL documentation
refsynopsisdiv
Hi,
While looking at the documentation on SELECT I noticed that the
entries in reference.sgml aren't sorted correctly -- psql \h does have
them in the correct order.
Attached a trivial patch to fix this.
In addition, reference.sgml doesn't have entries for TABLE or WITH
which should link to
Hi,
While trying to find instructions to build documentation, I noticed
that the links in README.git are broken, both redirect to
http://www.postgresql.org/docs/devel/static/
In addition, why isn't INSTALL stored in git?
Cheers,
Colin
--
Sent via pgsql-hackers mailing list
Hi,
According to http://www.postgresql.org/docs/9.3/static/sql-select.html#SQL-TABLE
The command
TABLE name
is completely equivalent to
SELECT * FROM name
It can be used as a top-level command or as a space-saving syntax
variant in parts of complex queries.
However, this isn't true:
Hi,
I can't get Postgresql to execute a query with EXCEPT (or INTERSECT)
as an anti-join (or join).
Is this even possible?
If not currently possible, is this something we would like to have?
Cheers,
Colin
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes
On 11 November 2013 14:34, Tom Lane t...@sss.pgh.pa.us wrote:
Colin 't Hart colinth...@gmail.com writes:
I can't get Postgresql to execute a query with EXCEPT (or INTERSECT)
as an anti-join (or join).
Is this even possible?
No, and it probably won't ever be, since the semantics aren't
On 11 November 2013 15:16, Tom Lane t...@sss.pgh.pa.us wrote:
Colin 't Hart co...@sharpheart.org writes:
On 11 November 2013 14:34, Tom Lane t...@sss.pgh.pa.us wrote:
No, and it probably won't ever be, since the semantics aren't the same.
EXCEPT/INTERSECT imply duplicate elimination.
Can't
On 11 November 2013 15:03, Tom Lane t...@sss.pgh.pa.us wrote:
Colin 't Hart co...@sharpheart.org writes:
I would've thought it was implemented as a shortcut for SELECT *
FROM at the parse level (ie encounter TABLE and insert SELECT *
FROM into the parse tree and continue), but it seems
Hi,
git status says that I'm on branch master.
psql reports 9.3devel, yet I expected it to report 9.4devel
Is this expected behaviour? I've looked at the developer's FAQ and Wiki but
couldn't find anything about this.
Cheers,
Colin
make distclean ./configure make sudo make install
helped.
Cheers,
Colin
On 21 October 2013 14:25, Michael Paquier michael.paqu...@gmail.com wrote:
On Mon, Oct 21, 2013 at 9:09 PM, Colin 't Hart colinth...@gmail.com
wrote:
git status says that I'm on branch master.
psql reports
Hi,
Here's a new version of a small patch to psql I'm using locally.
It adds a command \ns to psql which is a shortcut to set the
SEARCH_PATH variable.
I'd like to make a case for including this patch as it makes use of
schemas/namespaces much easier. There was resistance to including this
On 10 July 2012 18:00, Tom Lane t...@sss.pgh.pa.us wrote:
Josh Kupershmidt schmi...@gmail.com writes:
On Tue, Jul 10, 2012 at 2:09 AM, Colin 't Hart co...@sharpheart.org
wrote:
Attached please find a trivial patch for psql which adds a \n meta
command
as a shortcut for typing set
On 10 July 2012 18:24, David Fetter da...@fetter.org wrote:
On Tue, Jul 10, 2012 at 12:00:06PM -0400, Tom Lane wrote:
Josh Kupershmidt schmi...@gmail.com writes:
On Tue, Jul 10, 2012 at 2:09 AM, Colin 't Hart co...@sharpheart.org
wrote:
Attached please find a trivial patch for psql
Hi,
Attached please find a trivial patch for psql which adds a \n meta command
as a shortcut for typing set search_path =.
This allows you to navigate a database very quickly in psql as follows:
\dn
\n my_schema
\d
\d my_table
etc.
Not yet done: updating documentation (psql internal help,
Hi,
Attached please find a trivial patch for psql which adds a \n meta command
as a shortcut for typing set search_path =.
This allows you to use psql as follows:
\dn
\n my_schema
\d
\d my_table
etc.
Not yet done: updating documentation (psql internal help, psql man page,
main
Bruce,
To query for Postgresql services on Windows use:
sc query type= service | find postgresql
On my machine this yields:
SERVICE_NAME: postgresql-9.0
DISPLAY_NAME: postgresql-9.0 - PostgreSQL Server 9.0
NB the space after type= is very important, don't ask me why...
I prefer to use
Oops.
Apparently type= service is the default, so we can remove that bit.
Then we should add state= all. The default = active, a third option = inactive.
So:
sc query state= all
should list all services, in all states.
And then we pipe to find which is the Windows equivalent of grep, but
it
Hi,
Back in 2002 these were proposed, what happened to them?
http://archives.postgresql.org/pgsql-sql/2002-09/msg00406.php
Also I note:
co...@ruby:~/workspace/eyedb$ psql
psql (8.4.4)
Type help for help.
colin= select to_date('731332', 'YYMMDD');
to_date
1974-02-01
(1 row)
On 20 September 2010 16:54, Andrew Dunstan and...@dunslane.net wrote:
On 09/20/2010 10:29 AM, Colin 't Hart wrote:
Hi,
Back in 2002 these were proposed, what happened to them?
http://archives.postgresql.org/pgsql-sql/2002-09/msg00406.php
2002 is a long time ago.
snip
I think
Hi,
I note that the implementation of tab completion for SET TRANSACTION in PSQL
could benefit from the implementation of autonomous transactions (also
TODO).
Regards,
Colin
Ian Lance Taylor ( others) wrote:
This is true. However, a process-pool architecture would benefit
Postgres
on other platforms besides Windows. Postgresql has been ported to the
HP3000 MPE/iX operating system, for example, which is POSIX-compliant,
but
has an awfully slow fork().
On
Marc wrote:
Actually, the 'multi-day' delay is generally related to posts from ppl
that aren't subscribed to the lists that I have to approve manually ...
Is there a quick(er) way to 'subscribe, set nomail' on all the mailing lists
that are mirrored to news.postgresql.org?
I prefer to
Vince asks:
Everybody keeps saying bugzilla. What EXACTLY will bugzilla do for us
that would make me want to learn it and install it? BTW, the current
wheel was invented a year ago 'cuze nothing really fit what we needed.
The reasons I would choose Bugzilla:
1. It's *not* written by us so
Matthew T. O'Connor volunteered:
I don't know what a kibo is, but I would be willing to put in some time
helping maintaing a bug reporting system. One of the helpful things with
bugzilla setup with some other big projects is that the bug gets assigned
to
a developer and the bug submitter
Jan Wieck said:
Has anyone thought of using Bugzilla? (It is MySQL based, of course) but
it
might answer the bug database issues. (If you guys want a bug database)
Bug tracking software that doesn't use transactions and
referential integrity in a multiuser environment?
We could install the Postgres version of Bugzilla.
Yes, there's a version that runs on Postgres rather than MySQL.
That way we don't have to maintain the bug system.
Ok the functionality as well as the menu item are gone. You do realize
it's going to give the impression that we're trying to
Philip Warner wrote:
I don't think this is a good solution. We really do need a list of bugs.
We
probably need to list status and the releases they apply to.
Bugzilla can do this -- it has the concept of a Milestone and a Version.
I don't think anybody but the most naieve (or biased) users
Should we add this to /contrib?
I think so, at least until we get something better.
Cheers,
Colin
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so
31 matches
Mail list logo