Re: Help with SQL

> On May 27, 2018, at 6:42 PM, anand086 wrote: > > Hi, > > I have a requirement of writing plpgsql function to create partial indexes > on child tables if it exists on parent table. The function will have > schemname, childtablename, tableowner as input. > > I am using

Help with SQL

Hi, I have a requirement of writing plpgsql function to create partial indexes on child tables if it exists on parent table. The function will have schemname, childtablename, tableowner as input. I am using the below code to identify the indexname and index definition from parent table -- ```

How to reply to an existing bug?

I found an existing bug report and have something to add to it. What's the best way to reply to it? Just using a browser, with no newsreader installed. This one:

Re: case statement within insert

On Fri, May 25, 2018 at 10:19 PM, Adrian Klaver wrote: > On 05/25/2018 07:05 AM, Adrian Klaver wrote: > >> On 05/25/2018 06:52 AM, Adrian Klaver wrote: >> >>> On 05/25/2018 02:04 AM, tango ward wrote: >>> I want to insert data from mysql into a table in

Re: existence of a savepoint?

On Sunday, May 27, 2018, Stuart McGraw wrote: > Is there some way to to test if a savepoint of a given name > exists? Or better yet, the number of stacked savepoints of > that name? > A scan of the documentation doesn't show any commands or functions that would provide

existence of a savepoint?

Is there some way to to test if a savepoint of a given name exists? Or better yet, the number of stacked savepoints of that name?

Re: Syndicating PostgreSQL mailing list to Discourse

On Sun, May 27, 2018 at 6:13 AM, Stephen Frost wrote: > I'm curious what would be different here from what our archives provide. > We could certainly have a single "all lists" archive page but that seems > more likely to be just completely confusing than actually useful at

Re: UPDATE from CTE syntax error

On Sat, May 26, 2018 at 6:37 PM, Adrian Klaver wrote: > > > https://www.postgresql.org/docs/10/static/sql-update.html > "column_name > > The name of a column in the table named by table_name. The column name > can be qualified with a subfield name or array

Re: Syndicating PostgreSQL mailing list to Discourse

Greetings, * Erlend Sogge Heggen (e.so...@gmail.com) wrote: > Since it's read-only it would only be used for things like: > >- Fast search with advanced filters (Discourse puts PostgreSQL full text >search to good use!) While it might not be the case for other projects, we actually do