I'm trying to install postgre and it's giving this error. At first I thought I had somehow failed to download the installer but, I downloaded the installer twice and it gives the same problem. Anyone who knows anything gives me that strength ok....
Explaining the title:
I have a table called projects, these projects can be approved or disapproved.
Each insertion or update of a record in the project table is stored in a history table (eg I saved a project and then updated 2 times / In...
I would like to know if I can do a similarity lookup in a field of type character varying in PostgreSql.
For example: The name I have written to the table in the name field is Tauros and I'm looking for Taurros . I wante...
What kind of variable do I use to store an image in the database? And is there a specific command for this? or just insert as any record?
I have a project in the language lua (mobile by corona sdk) that the person has to take a photo and I ne...
I have a form with a field of type month , which sends a value in the format Y-m to my controller. How do I search the records for the selected month and year?
I'm using l5-repository
I did this, but it does not work:
$dat...
Error
SQL Error: ORA-00911: Invalid character
00000 - "invalid character"
* Cause: identifiers may not start with any ASCII character other than
letters and numbers. $ # _ are also allowed after the first
character. Identifiers...
What's wrong with this Stored Procedure?
CREATE OR REPLACE FUNCTION public.sp_teste
(
IN varchar,
OUT codigo integer,
OUT setor varchar,
OUT grupo integer
)
RETURNS SETOF record AS
$$
begin
return query SELECT co...
I need to make a search return similar words to me
I found the phonetic search it can even be used to refine the search I need, but I do not think that is ideal.
For example, in a database I have several professionals, but your professio...
I am a beginner in PostgreSQL and I need to make a INNER JOIN to relate data from two tables. It took me a long time to figure this out from FOREIGN KEY , but I made the right reference in the database. Now, I have a C # application...