Jul
17 |
|
comment |
How to add default value 0000-00-00 to date datatype in postgresql? I get why you're doing this. I also which there was a way to store a 'zero' date like '0000-00-00' as a default, which would allow an application to treat it as an initial value, instead of having to deal with a null database value. |
Jul
15 |
|
awarded | Notable Question |
Jun
22 |
|
asked | Will a cat run away if you lock it out the house for a night or two? |
Jun
13 |
|
comment |
Getting a slice of keys from a map I'm just starting to learn Go and am a little aghast that there is not a built-in method to get the list of keys from maps. |
May
12 |
|
awarded | Populist |
May
9 |
|
awarded | Autobiographer |
May
9 |
|
asked | Name of the behavior where kids change the rules so they can win |
May
2 |
|
awarded | Popular Question |
Apr
30 |
|
awarded | Notable Question |
Apr
19 |
|
comment |
Faster alternative in Oracle to SELECT COUNT(*) FROM sometable I just deleted a large number of entries from a table (over 480 million) so that now there are under 100K. SELECT COUNT takes forever, but gives the right answer. SELECT NUM_ROWS FROM ALL_TABLES gives me over 600 million entries. As per @Joseph 's comment, that information is not up-to-date. |
Apr
12 |
|
accepted | Dynamic SQL queries in sqlx |
Apr
2 |
|
comment |
Dynamic SQL queries in sqlx Perhaps I should have been more explicit; identifying columns is part of the requirement. The other is iterating over the result. I can seem to do neither. When I try with PgRow, the only functions that rust-analyzer shows me are into, try_into, borrow, borrow_mut and type_id. No other properties or anything. Am I missing an import? |
Apr
2 |
|
asked | Dynamic SQL queries in sqlx |
Mar
27 |
|
awarded | Popular Question |
Mar
18 |
|
accepted | How to add element to vector and return reference to that element? |
Mar
18 |
|
comment |
How to add element to vector and return reference to that element? Thank you, that worked! But how does the compiler allow that without breaking the ownership contract? I thought that, because the vector now owns the reference, you cannot give a mutable reference of it to another function? |
Mar
18 |
|
asked | How to add element to vector and return reference to that element? |
Mar
12 |
|
awarded | Good Answer |
Feb
21 |
|
answered | PostgreSQL: use subquery for domain value check |
Feb
20 |
|
comment |
PostgreSQL: use subquery for domain value check @Bergi I notice Oracle also does not support this. But why should you not be able to do it against a list that might change? After all that is what an FK constraint does. Only that requires more setup. |