#ChatGPT

Post a job Follow
0 Followers · 42 Posts

ChatGPT is an artificial intelligence (AI) chatbot developed by OpenAI. It is built on top of OpenAI's GPT-3.5 and GPT-4 families of large language models (LLMs) and has been fine-tuned using both supervised and reinforcement learning techniques.

Post a job Follow
Question Alexey Nechaev · Dec 4, 2023

PROCEDURE and ReturnResultsets

Hi folks, 

I made a solution (https://openexchange.intersystems.com/package/iris-pretty-gpt-1) and want to use it like 

CREATE FUNCTION ChatGpt(IN prompt VARCHAR)
RETURNS VARCHAR
PROCEDURE
LANGUAGE OBJECTSCRIPT
{
    return ##class(dc.irisprettygpt.main).prompt(prompt)
}


CREATE TABLE people (
name VARCHAR(255),
city VARCHAR(255),
age INT(11)
)


INSERT INTO people ChatGpt("Make a json file with 100 lines of structure [{'name':'%name%', 'age':'%age%', 'city':'%city%'}]")

I know that a FUNCTION can only return one result.

#InterSystems IRIS #ChatGPT #SQL
6
0 458