Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Favorites infavorites:mine
infavorites:1234
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with Search options user 39347

All versions of PostgreSQL. Add an additional version-specific tag like postgresql-11 if that context is important.

4
votes
1answer
Why does null and true evaluate to null in PostgreSQL but null or true evaluates to true? I would have thought using null with and or or would've evaluated to null in both cases? …
asked Dec 21 '17 by cdmckay
2
votes
2answers
In our app, we have assignments. We create this by unioning two other tables with a due_date column: checklists and tasks. We want to order assignments by the due_dates. Right now, we are doing someth …
asked Dec 1 '17 by cdmckay
9
votes
2answers
has an index, is the index calculated once in the first case, and twice in the second case? Or is it always once per insert? Assume that both queries are in the same transaction. I'm using PostgreSQL. …
asked Sep 11 '14 by cdmckay
2
votes
This is what I ended up going with: create table blog_posts ( id uuid not null, tenant_id uuid not null, title text not null, content text not null, primary key (id) ); create un …
answered Jun 6 '15 by cdmckay
3
votes
1answer
I have a multi-tenant app in PostgreSQL that has a repeated tenant_id column in each table to help isolate the tenants from each other. My question is, is there any sort of way that I can use …
asked Jun 5 '15 by cdmckay
1
vote
0answers
I have two tables tags and tag_memberships in a PostgreSQL database. On the tag_memberships table, I have two constraints. The first is this: ALTER TABLE tag_memberships ADD CONSTRAINT …
asked Jun 29 '15 by cdmckay