User Neil McGuigan

53 votes

7 answers

158k views

How to get all roles that a user is a member of (including inherited roles)?

asked Jan 3, 2014 at 22:07

24 votes

1 answer

40k views

What limits the number of connections?

asked Mar 19, 2015 at 21:50

20 votes

2 answers

23k views

How to do incremental backup every hour in Postgres?

asked Jul 8, 2013 at 5:17

13 votes

2 answers

18k views

How can I use an environment variable in a Postgres function?

asked Oct 25, 2013 at 18:08

8 votes

1 answer

3k views

Can I have an InnoDB master and MyISAM slaves with Full-Text for searching?

asked Aug 14, 2012 at 0:19

8 votes

1 answer

5k views

Fastest way to get the length of the intersection of two text arrays in PostgreSQL

asked Feb 6, 2014 at 0:40

7 votes

2 answers

7k views

How to implement soft deletes?

asked Feb 15, 2012 at 18:51

7 votes

1 answer

10k views

Fastest way to get current user's OID in Postgres?

asked Jan 9, 2014 at 19:01

5 votes

4 answers

6k views

How do I use an Ispell dictionary with Postgres text search?

asked Jan 19, 2014 at 3:02

5 votes

2 answers

2k views

How to sync a database with an external full text engine?

asked Feb 20, 2012 at 19:36

4 votes

1 answer

456 views

What does "unpackaged" mean in PostgreSQL extensions?

asked Feb 4, 2014 at 4:59

4 votes

2 answers

1k views

Geographic Hierarchies in a OLAP Cube / Data Warehouse

asked Jul 10, 2013 at 20:51

4 votes

2 answers

360 views

What is a standard or conventional name for a column representing display order? [closed]

asked Jul 31, 2013 at 19:59

3 votes

1 answer

158 views

Geographic Synonyms

asked Dec 16, 2013 at 21:40

3 votes

1 answer

603 views

What is the name of this type of query, and what is an efficient example?

asked Jul 6, 2013 at 18:58

3 votes

2 answers

542 views

Is a trade-in its own purchase order, or an adjustment on a sales order?

asked Jun 27, 2012 at 6:39

3 votes

2 answers

1k views

Marking duplicate records

asked Nov 20, 2014 at 23:20

2 votes

0 answers

29 views

How to retrieve the distinct domains of a compound domain from DQS using SSIS?

asked May 6, 2016 at 0:39

1 vote

1 answer

650 views

Wildcard subnet mask for IPv6

asked Jul 10, 2014 at 19:29

1 vote

2 answers

5k views

PostgreSQL get first letter of each word (except...)

asked Aug 25, 2014 at 18:37

1 vote

1 answer

3k views

How to serialize a record / row in SQL?

asked Feb 16, 2012 at 1:36

1 vote

1 answer

1k views

Which Optimistic Concurrency Control method will work out best in the long run?

asked Apr 17, 2012 at 2:33

0 votes

2 answers

907 views

How to implement Draft functionality, with attached files?

asked Feb 15, 2012 at 19:00

Stack Exchange Network

23 Questions

How to get all roles that a user is a member of (including inherited roles)?

What limits the number of connections?

How to do incremental backup every hour in Postgres?

How can I use an environment variable in a Postgres function?

Can I have an InnoDB master and MyISAM slaves with Full-Text for searching?

Fastest way to get the length of the intersection of two text arrays in PostgreSQL

How to implement soft deletes?

Fastest way to get current user's OID in Postgres?

How do I use an Ispell dictionary with Postgres text search?

How to sync a database with an external full text engine?

What does "unpackaged" mean in PostgreSQL extensions?

Geographic Hierarchies in a OLAP Cube / Data Warehouse

What is a standard or conventional name for a column representing display order? [closed]

Geographic Synonyms

What is the name of this type of query, and what is an efficient example?

Is a trade-in its own purchase order, or an adjustment on a sales order?

Marking duplicate records

How to retrieve the distinct domains of a compound domain from DQS using SSIS?

Wildcard subnet mask for IPv6

PostgreSQL get first letter of each word (except...)

How to serialize a record / row in SQL?

Which Optimistic Concurrency Control method will work out best in the long run?

How to implement Draft functionality, with attached files?